Updating a Listbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that uses a ListBox to allow the user to navigate to a record they can then edit. Editing one of the fields changes the value of one of the fields in the ListBox's RowSource. How do I get the ListBox to reflect this change immediately

Private Sub field1_AfterUpdate() 'field that is also in the RowSource for the Listbo

lstListbox.Requer

End Su

doesn't work

Thanks

Pa
 
Try adding lstListBox.Refresh into your code. Requery will update the
underlying data, but the form will not show the new info unless you perform
a refresh.

Kelvin

pmcguire said:
I have a form that uses a ListBox to allow the user to navigate to a
Click to expand...
record they can then edit. Editing one of the fields changes the value of
one of the fields in the ListBox's RowSource. How do I get the ListBox to
reflect this change immediately?
 
Back
Top