Query Help!!

Hi!
I am trying to create a query that uses the values I have in a form as
the criteria. THe form has three tables and you can select which
fields you want from each of the three tables. Ultimately you are left
with three fields that are going to be compared (there values from
different budgets). I could do all of the math stuff once I get the
three fields to show up in the select query that I cannot set up right
now. If anyone can help me it would be greatly appreciated.

Thanks in advance for your time.

~Brian

To use a form field as criteria you would put:
Forms!YourFormName!YourFormFieldName in the criteria of your query
field. Obviously you need to substitute the correct values.

Hope that helps!

I have tried putting criteria in the query but I still get no results.
I am still not sure which field to put in the query if I am trying to
use the field selected in the form combo boxes.

SHould I be doing something else Like a look up or open table macro?? I
am just lost at this point.

Thanks for the response!

~Brian

Jeff L wrote:
To use a form field as criteria you would put:
Forms!YourFormName!YourFormFieldName in the criteria of your query
field. Obviously you need to substitute the correct values.

Hope that helps!

You use the name of the combobox on your form, whatever you have called
it. If you called it MyCombo then you would use that in the criteria.

Forms!YourFormName!MyCombo

Hope that makes better sense.


BrianH wrote:
I have tried putting criteria in the query but I still get no results.
I am still not sure which field to put in the query if I am trying to
use the field selected in the form combo boxes.

SHould I be doing something else Like a look up or open table macro?? I
am just lost at this point.

Thanks for the response!

~Brian

Jeff L wrote:
To use a form field as criteria you would put:
Forms!YourFormName!YourFormFieldName in the criteria of your query
field. Obviously you need to substitute the correct values.

Hope that helps!