Custom Dialog

  • Thread starter Thread starter Michael Noblet
  • Start date Start date
M

Michael Noblet

I know this has been discussed proeviously, but I am still
strugling. I need to open a report built from a query,
but I want the user to eneter a date in a cstom dialog
box. then the on click event for a command button runs
the report for only the date that matches the user input
data.

I have done this in the past and can't seem to rememebr
what I did. A little direction on the on clink event
procedure would be helpful.

Mike
 
Simply have a date propt fonthe form

You can then with the buttion on the form to launch the report go:

docmd.OpenReport "myreport",acviewPreview,,"invoiceDate =
forms!MyForm!DatePrompt"
 
Back
Top