View Full Version : getting a parameter from Form to Report


nval005
07-10-2007, 10:24 PM
is there a way to say I enter a date on the date field in a form, and when I hit the report button, this report will grab that data from the date field and include it to the report. thank you in advance.

Michael J Ross
07-10-2007, 10:59 PM
Set the control source of the text box on your report to =Forms!NameofForm!Nameoftxtbox, substituting your actual form name and name of text box that holds the date.

The form will have to remain open when the report runs.

nval005
07-10-2007, 11:43 PM
thanks for the help !!! :) it works.......oh yeah...