By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,109 Members | 932 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,109 IT Pros & Developers. It's quick & easy.

More form problems

P: n/a
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?

Aug 3 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

<gn@dana.ucc.nau.eduwrote 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

Aug 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.