requery controls on nextrecord (1 Viewer)

[torok]

I've got a listbox on an Invoices form. The listbox is populated by a query that references the Invoice ID (ie. the record number) that's on the form. The control source for the listbox is blank, (has to be because I do other stuff with the data in the box). When I click the navigation button that goes to the next record, the listbox does not requery to show data based on the new invoice number. I tried putting a requery in the AfterUpdate and the Activate events of the Form, but that didn't help. Any suggestions?? I've searched the archives and the MSDN docs for over an hour now.....

Thanks!
Tom

 

[Jack Cowley]

Try a Me.ListBoxName.Requery in the On Current event of the form.

 

[torok]

Thanks! It works!