Passing criteria parameters

funderburgh

Registered User.
Local time
Today, 10:27
Joined
Jun 25, 2008
Messages
118
OK, I'm stuck. I have a tabbed interface with subforms for various functions. On the Print function subform I run a query-based report that takes criteria for two items from the form: [Forms]![Main Navigation]![SchoolYear] is one.

When I run the report the result looks as though the query brought up no records. I believe that the query is getting criteria from the form because I am not prompted for it. When I run the print function subform alone, the query prompts me for the criteria and the report and works fine.

Can I display in some fashion the value the query is getting from the form for the criteria?

Thanks for any help.
 
In query criteria put:
[Forms]![MainFormName]![SubFormName]![FieldName]
 

Users who are viewing this thread

Back
Top Bottom