How make listbox requery or refresh when go to a new or different record
Posted on 2009-05-15
I have a form which contains a listbox. On the form I have created a new record button. When I click on the new record button the listbox is not refreshing or requering the data associated to the record number of the form. The listbox is driven by a query which has criteria set to use the record number from the form itself. What am I doing wrong? I have tried...
DoCmd.GoToRecord , , acNewRec
on the onclick event of the new record button but that isn't working.