Updating a Listbox

[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

 

[Kelvin]

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

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?