null responses

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a report which takes its parameters from a form (with one
text box and one combo box). If the user forgets to enter the criteria in
either the text box or the combobox, he should get the message box asking him
to input the missing information and the form shows up again. How can I
achieve that? Also, each time when the report is run, the text box and combo
box in the form should be empty.
I appreciate your help in this regard. thanks.
Purnima sharma
 
Purnima,
I would imagine you have a button on the form that opens the report. Place code just
before the OpenReport to check that Combo1 and Text1 are not null. If Null, post message
to user, and Exit the Sub "before" opening the report.
Use the OnClose event of your report to Null out the values on your form. Your form
must be open, and the values must exist... while the report runs.
 
Back
Top