choose multiple values from table

  • Thread starter Trying to Finish
  • Start date
T

Trying to Finish

how do I choose multiple values from a table and have all values show as a
list in a form.
 
G

George Hepworth

You might be looking for the functionality of a list box.
Or you might be looking for the functionality of displaying the form as a
Datasheet or Continuous View form.
 
T

Trying to Finish

thanks

George Hepworth said:
You might be looking for the functionality of a list box.
Or you might be looking for the functionality of displaying the form as a
Datasheet or Continuous View form.
Click to expand...
 
T

Trying to Finish

I tried the list box but how can I choose more than one value from the list
box?
 
J

Jack Cannon

Use the MultiSelect Property on the ListBox.
Set it to either Simple or Extended depending on your preference.

Jack Cannon
 
G

George Hepworth

List boxes have a property which can be set to allow selection of a single
item, or multiple items. It's called "Multi Select", and you'll find it on
the "Other" tab of the property sheet for the form. The three choices are
"None", "Simple" and "Extended". You can check the different behaviors of
Simple and Extended select to see which best suits your preferences.

Note that USING the items selected in a multi-select enabled list box is
also a bit more complex than in a single select. Post back if you have
further questions.
 
T

Tom Wickerath

Here is a simple example that shows how to use VBA code to "iterate" the
..ItemsSelected property of a multiselect list box. As others have already
mentioned, you set the multiselect property on the Other tab of the
properties dialog:

http://www.accessmvp.com/TWickerath/downloads/elements.zip

Here are some other QBF (Query By Form) samples that make use of multiselect
list boxes:

http://www.accessmvp.com/TWickerath/downloads/Chap08QBF.zip

http://www.seattleaccess.org/downloads.htm
See the download "Query By Form"
Tom Wickerath, February 12, 2008


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
Top