Union on Combo boxes

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

Guest

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
 
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.
 
The FROM with "all values" has no significance. Take MSysObjects, that
table is never empty.
 
Back
Top