Filtering a combo box using a combo box

[Turner.John.P]

All,

I am trying to filter the records from a table displayed in a combo
box using a combo box on the same form. I built a query and set the
criteria as Me![FormName]![Combo_box]. This allowed me to filter the
list, but it did not do exactly what I wanted. When the first combo
box is blank, the second one is also blank. Is there anyway I can get
the second combo box to display all of the records when the first box
is blank?

Thank you for your help.

Regards,

John

 

[Arvin Meyer [MVP]]

Try a criteria in the second combo of:

Like Forms!YourFormName!Combo1Name & "*"

 

[Turner.John.P]

Try a criteria in the second combo of:

Like Forms!YourFormName!Combo1Name & "*"
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

All,

I am trying to filter the records from a table displayed in a combo
box using a combo box on the same form. I built a query and set the
criteria as Me![FormName]![Combo_box]. This allowed me to filter the
list, but it did not do exactly what I wanted. When the first combo
box is blank, the second one is also blank. Is there anyway I can get
the second combo box to display all of the records when the first box
is blank?

Thank you for your help.

John- Hide quoted text -

- Show quoted text -

That worked. Thank you for the help.

John