List Box

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

Guest

I have alist box with specific data to be displayed. When I add a new record
I am able to view the list box and select one of the items in the list...but
when I save ther record it doesn't input the field informatin I sleected from
the listbox in the record. What did I miss.

ie...
Add a new record using a form where one field is a list box.
View table in datasheet view...the field bound to the list box is empty.
 
Set the List Box' Control Source property to the name of the field where you
wish to store the selection. The field's type must match the type of data in
the list box' Bound Column.

Sprinks
 
I must have something else wrong. When I open my form to add a record and
select the field from the list box and complete other fields; I click the new
record button. When I open up the table in datasheet view the field is blank
with a pulldown arrow to select the field. I already selected it on the
form. The other fields that I completed in the form show up correctly in the
datasheet. For some reason the list box information is not sticking with new
records.

Thoughts? I appreciate your assistance.
 
Please post the following properties of the list box:

ControlSource
RowSource
ColumnCount
BoundColumn

Please also post the code attached to your New Record button.

Sprinks
 
Category
(Type) Value List
Education;Law Enforcement;Mental Health
1

No code that I added. I just use the form with Data Entry and the record
selection buttons.

Thanks!!!!!!
 
I don't understand why it isn't working. First try repairing the database
(Tools, Database Utilities, Compact and Repair). If that doesn't fix it, I'd
be happy to take a look at it for you if you made a copy of your database,
removed all but one or two sample records, and emailed it to me. Remove
"NOSPAM" from the following address:

(e-mail address removed)

Sprinks
 
Back
Top