Form Update problem

[andriulli]

Hello, I'm pretty new to Access so I'm learning as I go. Here is my
problem:

I have a form that shows a bunch of details about a piece of equipment
based upon the EquipID. I have arrow buttons on the bottom of the form
that allows me to go to the next or previous record without a problem.
I then put in a listbox that lists all the pieces of equipment in the
database via their EquipID. I bounded this listbox's first column to
the EquipID field of the form. When clicking on the arrow buttons, or
selecting a field in the listbox, the EquipID field on the form
updates, but none of the rest do. This causes the form to want to
change all the data for the selected EquipID.

Question: How can I force the form to update ALL of the record data
when selecting a new item in the listbox?

Thanks.

 

[Allen Browne]

To use a list box to navigate through the records of the form, it must be an
*unbound* list box (i.e. Control Source is blank) so it is not changing the
value of the EquipID in the current record.

Then you can add code to the AfterUpdate event of the list box to move the
form's record. The code will be like this:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

 

[andriulli]

Thank you so much! I can't tell you how frustrating that was, lol.