Combo box does not update with new data

  • Thread starter Thread starter Deb Nitz
  • Start date Start date
D

Deb Nitz

A combo box on the form allows a user to look up a vendor
name. This works correcltly and all fields on the form
display the correct vendor information for the vendor that
was chosen from the combo box. But when the navigation
buttons on the form are used to move to another record,
the fields on the form change accordingly but the combo
box does not update and shows the wrong (old) Vendor Name.

Thanks,

Deb
 
Depending on the query that your using for your ComboBox,
this might work.

In the OnCurrent() event, requery the ComboBox, using
Me![ComboBoxName].Requery.

This will run everytime you navigate to a new record and
should correctly update the list.
 
A combo box on the form allows a user to look up a vendor
name. This works correcltly and all fields on the form
display the correct vendor information for the vendor that
was chosen from the combo box. But when the navigation
buttons on the form are used to move to another record,
the fields on the form change accordingly but the combo
box does not update and shows the wrong (old) Vendor Name.

Thanks,

Deb
Click to expand...

Using the combo box to navigate to a Vendor? I assume (and hope) that the combo box is unbound (or you would be changing the
current Vendor Name when you use it). If it's unbound, it won't update. On the Current event of the form you can set the
combo box to be the current Vendor.
Jeremiah Ellison
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top