Passing multiple variables 1

[HMJ]

I am advancing into another new area for me in the VBA arena. I am trying to pass variables to a report query. I have passed one variable – i.e. year – before, but now I am trying to pass two or three variables.

In a query we might see:
Class Date Grade
=3 =02/10/03 >75
This would be hard coded into the query. Now I am using a drop down in a form where the class and/or date and/or grade breakpoint can be selected. This info needs to get to the query when I run the report.

Can anyone help me?

Thanks.


Harry Jessen
HMJessen@Yahoo.com

 

[cghoga]

hi Harry.

instead of entering hardcoded values like in your example
above, you will need to reference the field value on the form directly.

to do this, insert the following in the criteria section of the field you're referencing.

Forms!NameofYourForm!FieldName.value

Replace NameofYourForm and FieldName as is applicable to you.

if on your form, you want to leave this field blank sometimes, and have Access skip the field in the query process, include the following instead.

Like iif(Forms!NameofYourForm!FieldName.value is null,"*",Forms!NameofYourForm!FieldName.value)

hope this helps you.