Date parameter

C

Carrie

On my form I have a command button to open up a report from a query. I
wanted to know if there was a way to add a date parameter to the command
button so when my report opens it only reflects that date?
 
A

Arvin Meyer MVP

Carrie said:
On my form I have a command button to open up a report from a query. I
wanted to know if there was a way to add a date parameter to the command
button so when my report opens it only reflects that date?

Sure the button code would look something like:

DoCmd.OpenForm "FormName", , , "DateField = #" & Me.txtDateField & "#"
 
Top