Combo Box Selection

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi,

I have combo box working for list of states from table without "United
States". When I select Florida, I got the query for Florida only. I would
like to see "United States" in a combo box not from TABLE along with the
states. If I select "United States" from the combo box, it will give me
all the states.

Can you help me? Your help would be much appreciated.

Thanks.. :-)
 
Bill said:
Hi,

I have combo box working for list of states from table without "United
States". When I select Florida, I got the query for Florida only.
I would like to see "United States" in a combo box not from TABLE
along with the states. If I select "United States" from the combo
box, it will give me all the states.

Can you help me? Your help would be much appreciated.

Thanks.. :-)
Click to expand...

If I understand your question correctly, this is pretty much the same as
described here:

http://www.mvps.org/access/forms/frm0043.htm
Adding "All" to a listbox or combobox
 
Back
Top