Data Selection

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

Guest

My database is structured to allow users to create a product record and input
multiple locations for this product using a subform (up to 100 locations). I
am using a drop-down for the locations. Is there a way to choose multiple
locations from a list at once? It is very time consuming to individually
select location numbers for each product record. I was hoping to learn of a
way to select multiples from a list or, perhaps, show a table with all
locations from which I could have the user simply click the desired
information. Suggestions are welcome.
 
Tojib,

Combo boxes do not support multiple selection. Listboxes do, but then you
can only "read" the selections through VB code. Very good if you know how,
not easy if you don't (but as good an opportunity as any to get into VB!).
Another alternative that does not necessarily require coding is the use of
an auxiliary table with fields, say, LocationID, LocationName, Select
(yes/no field). You can put this table in a subform or a separate form
altogether, and the user just checks desired locations, the rest being
handled by action queries. You could even add a Select All and a Clear All
command button to fire an appropriate Update query each.

HTH,
Nikos
 
Back
Top