ComboBox & SubComboBox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a MASTER combo box and a SUB combo box. The SUB gets its values from
a query linked to MASTER. My problem:

The SUB looks up its related values just fine, but I want it to have an
extra option of "Any". So, the combo box will list the queried values and
"Any". This way the user isn't forced to select a SUB value, then can simply
select "Any" and all records under MASTER will go through.

Thanks for any advice,

Jeff
 
One way to do it is to alter the rowsource for the combo box to include a
UNION with a bogus record like UNION (SELECT -1 AS BogusPK, '<All>' AS
BogusName FROM whateverYourTableIs) after the current SELECT statement and
before any ORDER BYs.

hth

Jayyde
 
Back
Top