how do i select multiple items on a form

[Timmy]

how do i select multiple items on a form to update a bound table

 

[Klatuu]

Sorry, Timmy, but your question is too vague. You don't select which
controls on a form will be included in an update. The entire current record
is updated in the table (or query) when the form is updated.

Perhaps you can restate your question or add some more detail.

 

[Timmy]

My bad, I should have been more specific. I have a list box that shows
values (# of beds in hospitals) from the qry. The selection I make updates a
field (# of beds) a bound table (Beds). If I select only one (Multi select
is not enabled) of four possible choices the table (Bed) updates fine. If I
select more that one (multi select is enabled) the table (Bed) is blank. I
am relatively new to this, so it is quite possible I am missing something
obvious.

 

[Klatuu]

Now it all make sense.
A multi select list box is a different beast. It does not return a value
like any other control. It can't, because it doesn't contain one unique
piece of data. When you query a multi select list box like this:

x = Me.MyListBox

It will return Null.

A multi select list box contains a collection named ItemsSelected. It will
be a list of all the selected items. For a good example of how to addess
this, see VBA Help for ItemsSelected.

 

[Timmy]

Is there another way to do this without using a multi select text box?

 

[Timmy]

Is there another way to do this with out using a multi select text box?

 

[Klatuu]

Do what, exactly?

Is there another way to do this with out using a multi select text box?

 

[Timmy]

Update a table with multiple selections from a Form