choose multiple values from table

[Trying to Finish]

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

 

[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.

 

[Trying to Finish]

thanks

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.

 

[Trying to Finish]

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

 

[Jack Cannon]

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

Jack Cannon

 

[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.

 

[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/
__________________________________________