Creating combo box

H

hagen31

I have two databases Hardware and monitors. One of my fields in hardware is
called Location. Each loaction is listed multiple times and I want to be able
to select a location from a combo box in the form. All the locations I should
need are already in my table, but I want the option to be able to add new
ones. So I want to group all the locations(say I have multiple locations of
X) into one instance of X so I don't see all of them in my combo box. Can
anyone help?
 
K

Klatuu

create a query on Hardware that has only one column - Location.
Make it a select totals query with the group by option. Then make this
query the row source for your combo. It will present each location only
once.
 
Top