Query Criteria from a Selection

[Mike S.]

I am trying to "parameter" query two related tables which
is intended to return one record based on the criteria I
want to enter for the subject field.

Instead of manually typing the criteria in Access's dialog
box prompting me for such data, is their a way for me to
enter this variable criteria with something like a Combo
or List Box?

I already have a Combo Box for this field in the Form for
one of the tables in this query.

I have tried numerous combinations of expressions in the
criteria block of the query, but I either get back errors
or many more records than I anticipated.

Your help would be greatly appreciated!

 

[Ken Snell]

Proper syntax to reference a form's control as a parameter in a query:

[Forms]![FormName]![ControlName]

 

[Guest]

Thanks. That worked perfectly. Appreciate the help!

-----Original Message-----
Proper syntax to reference a form's control as a parameter in a query:

[Forms]![FormName]![ControlName]


--
Ken Snell
<MS ACCESS MVP>

I am trying to "parameter" query two related tables which
is intended to return one record based on the criteria I
want to enter for the subject field.

Instead of manually typing the criteria in Access's dialog
box prompting me for such data, is their a way for me to
enter this variable criteria with something like a Combo
or List Box?

I already have a Combo Box for this field in the Form for
one of the tables in this query.

I have tried numerous combinations of expressions in the
criteria block of the query, but I either get back errors
or many more records than I anticipated.

Your help would be greatly appreciated!

.