Union on Combo boxes

J

Johny

Hello,

I have a combo box with its controlSource is:
select "All values" from aTable union select * from aTable

The problem is that when there is no record on aTable nothing is visible
when you drop down list.

Any suggestions?

Thanks Johny
 
R

Rick Brandt

Johny said:
Hello,

I have a combo box with its controlSource is:
select "All values" from aTable union select * from aTable

The problem is that when there is no record on aTable nothing is
visible when you drop down list.

Any suggestions?

Thanks Johny
Click to expand...

Pick a table for the first part of the union that will always have a record in
it. Since the SELECT is on a string constant it doesn't really matter which
table you use there.
 
B

Bas Cost Budde

The FROM with "all values" has no significance. Take MSysObjects, that
table is never empty.
 
Top