Dan

Queries don't have comboboxes, forms do.

You could use a reference in your query to the value that was selected in a
form's combobox, and this is a common way of creating a combobox-guided
query.  You need to create a form and work from there, not directly in the
query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

If you are entering directly into a table (or query) then there is no way to
accomplish what you want to do.  IF you are entering data into a form, then
there is a possibility of doing what you want.

In a continuous form, the solution can be a bit complex.  On a continuous
form, there is only one control shown many times (once for each row).  So if
you change the row source of a combobox depending on the row you are in, other
rows that need other values to display will suddenly display blank.  The data
is still in the table, the problem is that the combobox control does not have
that particular value available to display.

So, post back if you are using a form to display and modify the data.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County