Take this a step at a time until you find where the problem lies.
1. Open the Immediate Window (Ctrl+G).
Type this, and press Enter:
? [Forms].[Form1].[Combo0]
If you do not get the value of the combo on the form, fix the names and keep
trying until you get it right.
2. Once you have the expression right, go back to the query, and paste it
into the Criteria under the field. Then choose Parameters on the Query menu,
and enter it there as well with the correct data type. For example, if you
pasted it under a field of type Number (size Long Integer), you would enter:
[Forms].[Form1].[Combo0] Long Integer
If that still fails, switch your query to SQL View (View menu), copy the SQL
statement, and post it here. Also provide:
a) Details on the field you are attempting to use this criteria on: what
Data Type is it when you open the table in design view.
b) Details on these properties of the combo:
Control Source
Row Source
Bound Column
Column Count
Format
Column Widths
The combo's not in a subform?
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
Johnny5 said:
that's the issue...I have done this untill I am blue in the face and it
WILL
NOT accept this....
It just keeps telling me that the jet database doesn't recognise this
expression.....
Any clues?
Allen Browne said:
In query design, in the Criteria row under the field you want to filter,
enter:
[Forms].[Form1].[Combo0]
Substitute your form name for Form1.
Substitute your combo name for Combo0.
Johnny5 said:
I have set up a form with a combo box.
I have also set up a query. I want the combo box to operate one field
in
the query to act as a "filter" to return a simple result but Access is
NOT
user friendly and every expression builder I have tried to "link" the
combo
box with the query from the form will NOT work...PLEASE HELP!
