Question on Empty Date

[ramrags]

I have a form with a job start date and a job end date,
also I have a cmd button on the form which is made from a
label thats prints a job report. When you click the button
I want to check if the text box "job_end_date" if filled in and if not get a msgbox to put the date in. I cant get it to work with null or "" Thanks for any help

 

[scriverb]

Use the following in the OnClick of the cmdButton:

If IsNull(me.Job_Start_Date) then
MsgBox "The Job Start Date is empty."
me.Job_Start_Date.setfocus
end if
If IsNull(me.Job_End_Date) then
MsgBox "The Job End Date is empty."
me.Job_End_Date.setfocus
end if
DoCmd.OpenReport "rptJobsReport"

This should work for you. If you have any further problems just post back and we can figure this out for you.



Bob Scriver

 

[ramrags]

Thank you very much, it was a dumb question but I just could not get it. Works now thanks again.

 

[scriverb]

Hey, there are no dumb questions. Glad to be of help.

Bob Scriver