When I go to next record ListBox won't update

[Gainger Gran]

How come if I put a textbox on my form and link it to a table then it gets
updated when I go to a new record, yet the same does not occur with a
ListBox?

 

[Guest]

Hi Gainger Gran,

It sounds to me like your listbox may not have a Control Source specified.
Open the form in design view. Click on View > Properties to display the
Properties dialog (if it is not already displayed). Select the listbox. You
should see the name of the listbox in the blue title bar of the Properties
dialog. Select the Data tab. The first entry reads Control Source. This is
the field that is used to store the value that you select in the list box.

Note: To use a listbox in this manner, you need to make sure that the Multi
Select property, found on the Other tab of the Properties dialog, is set to
None.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________