Filtering a combo box using a combo box

  • Thread starter Thread starter Turner.John.P
  • Start date Start date
T

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
 
Try a criteria in the second combo of:

Like Forms!YourFormName!Combo1Name & "*"
 
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,
Click to expand...
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?
Click to expand...
Thank you for your help.

John- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

That worked. Thank you for the help.

John
 
Back
Top