ComboBox & SubComboBox

[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

 

[Jayyde]

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

 

[Guest]

Perfect! It works exactly how I wanted.

Thanks,

jeff