grouping same values

H

hagen31

I have a table called computers and in there is a field called location. Any
location can have many computers. So when I created a form to add new
computers the location field listed every location in table(as it should with
the way I set it up), but since many of them are similiar and there is
basically only 5 locations(right now) is there a way I can group the similar
ones together to make it easier for the user. I know I could create a combo
box with a value list, but then as new locations arise I would have to go
into the form and the table to add this location in the value list. I would
like to have the ability to allow the user to add new locations. So, as a
computer comes in the user can add it with the form, and be able to set a new
location. And after that that location would become available from the drop
down box becuase it is a value in the table. Is this possible?
 
A

Al Camp

I take it your talking about a combo box that allows the user to select
any existing location.
Use a "Totals" query as the RowSource for your combo, and "Group" on
Location. Then the list will only show each unique value once.
 
H

hagen31

Al,

How do you "Group" by Location?



Al Camp said:
I take it your talking about a combo box that allows the user to select
any existing location.
Use a "Totals" query as the RowSource for your combo, and "Group" on
Location. Then the list will only show each unique value once.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Click to expand...
 
H

hagen31

I got the group but now the location that is assigned to a computer has
dissappeared on my form and any time I select a location all of the computers
have the same location.
 
Top