Query Criteria from a Selection

  • Thread starter Thread starter Mike S.
  • Start date Start date
M

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!
 
Proper syntax to reference a form's control as a parameter in a query:

[Forms]![FormName]![ControlName]
 
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!
Click to expand...


.
Click to expand...
 
Back
Top