a combo box using query values.
that query has 2 fields, ID and status
how to make a combo box that only shows the ID iff its status is available
when an ID's status change not available, that particular ID will disappear from combo box

a combo box using query values.
that query has 2 fields, ID and status
how to make a combo box that only shows the ID iff its status is available
when an ID's status change not available, that particular ID will disappear from combo box
That's in the query, select ID where Status=available.
Combo Box Wizard does not have option form option
Combo Box and Option Group Values