Multiple select listbox not holding on to values

G

Guest

Hello. I created a multiple select (extended) listbox field in my table and
then selected it from my field list to add to my form. When I select values
in the listbox and then move on to the next record, the field does not hold
on to the values I selected. That field in my table is also blank. I know I'm
missing something big here...what should my next step be after creating my
listbox field?

Thank you.
 
J

Jeff Boyce

Disregard the "you can't do this" response. It is either SPAM or something
worse. Follow the link at your own peril!

The person posting the response has used several different aliases, and is
now representing him/herself as an MVP.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
E

Ed Robichaud

There's some confusion in your terminology. Listboxes are a type of control
used on forms. Multi-select (extended) listboxes cannot be usefully bound
to a single field in your table. See below for using an unbound
multi-select listbox as criteria in a query.

http://www.mvps.org/access/forms/frm0007.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One listbox works but the others don't 5
Run select query from VBA code where criteria comes from a multi select ListBox 2
Access Cannot select items in listbox 1
Listbox-multiple selections 4
how to select multiple values for a field on a form 3
show multiple listbox values in a text box 1
Multi-select listbox 2
Create a Table with Multiple Values Listbox 0

Top