Replies

why not make date three invisible until the other two are filled in

if isnull date1 then
date3.visible = false

something like that
HTH
JerryC

sorry the box is to the right of the rowsource not to the left

JerryC

go to the rowsource of the ScaleValues combo box
click on the three dotted box to the left
this will bring up a query builder you can set whatever criteria you want here
HTH
JerryC

maybe its just me but i’m not sure what the question is
JerryC

sorry for not getting back any sooner
the problem wound up being with our IT department they were resetting the macro security on boot up that is why it worked when we wrote the macro but not the next time we tried it
thanks
for all your help
JerryC

try this <=Date()-7

you could add a button with code behind it to requery or if any fieds are being updated you colud put code on the after update event for that control
for the code you could try me.requery
that should work
hth
jerryc

DID YOU SET THE CRITERIA AS “IS NULL” OR Is Null. if you set the critera as “IS NULL” You will be searching for the actual words IS NULL instead of null
jerryc

if you have a field in your form that is unique like an autonumber field set the query criteria of the report to this control of the form.
them you can use a macro or code to open, print and close the report if you want

don,t know if matters but you list the fields as badge id on both tables
in you query you are showing badge id and id(autonumber ?) linked
could this be the problem
JerryC

where do you go to change the subdatasheet property in the tables
thanks
JerryC

Thanks Gary
I’ll give it a try as soon as I can
thanks again
JerryC

IT LOOKS LIKE THE SAVE PART IS WORKING
BUT DOES NOT CLOSE THE APPLICATION
I TRIED USING THE CODE IN ANOTHER PRESENTATION
AND THE CODE WORKED A FEW TIMES AND STOPPED WORKING IN THAT ONE TOO
PLEASE ANY IDEAS WOULD BE GREATLY APPRECIATED
THANKS
JERRYC

why not simply import the dbase table into your access database
JerryC

if you want 97 and 2000 on the same machine try this from the knowledge base
Q241141 – ACC2000: How to Install Access 97 and Access 2000 on the Same Computer
JerryC