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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top