More form problems

[gn]

I have a form that is used for adding, updating and deleting records in
a table, everything works fine except that one of the fields uses a
list box, this works fine for adding a new record but will not work for
updating a record, when you click off that record and back on it has
reverted to it's previous value. All the other fields which are
textboxes update just fine.

What is the difference?

[Larry Linson]

<[e-mail] in message
news:11**********************@m73g2000cwd.googlegr oups.com...

>I have a form that is used for adding, updating and deleting records in
a table, everything works fine except that one of the fields uses a
list box, this works fine for adding a new record but will not work for
updating a record, when you click off that record and back on it has
reverted to it's previous value. All the other fields which are
textboxes update just fine.

What is the difference?

There is certainly nothing inherent about a ListBox that would prevent it
updating its Control Source (if any).

The first thing to investigate is whether the ListBox on your form is
"bound" to a Field in the underlying RecordSource... in design view, click
on the ListBox, and if the Properties sheet is not visible, right-click and
choose Properties. Then, in the Data Tab, look at the Control Source
property.

If the Control Source does specify a Field, then click on the Events tab,
and see if there is processing specified for any of the Events for the List
Box. Then, click on the Form, and see if there is processing specified for
any of the Events for the Form.

Larry Linson
Microsoft Access MVP