requery listbox from a subform

icbiny

Registered User.
Local time
Today, 09:52
Joined
May 15, 2012
Messages
15
i have a button on a subform that appends to a table, working fine. i have a listbox on the parent form that shows the records in said table. my problem is i cant get the listbox to update when i click this button. i have to open and close the form to display the new record in the listbox. if it was all on the same form the answer would be "me.listbox.requery" but from a subform i cant seem to make it work.
it might be worth mentioning that a variable is needed as there are up to 31 different listboxes (a calendar).

thx in advance for any help :)
 
Try this [Forms]![formname]!
[listbox].Requery

The .Requery will not automatically popup but should capitalize itself once you press enter.

Good luck
 

Users who are viewing this thread

Back
Top Bottom