Requery subform listbox

[Dave_cha]

Does anyone know how to requery a listbox within a subform?
A popup form allows me to make changes to the underlying record source of the listbox. When I close out of the popup and return the main form I would like the list box within the subform to display the record updates.

I've tried the follow options but can't get it to work;

[Forms]![Main Form].[Subform].Requery
[Forms]![Main Form]![Subform].[Listbox].Requery
[Forms]![Subform].[Listbox].Requery

Thanks,

Dave

 

[gtech08]

I think the second one would work. Have you verified that your query works correctly?

I would also try "[Forms]![Main Form]![Subform]![Listbox].Requery" in the On Close event of your popup form.

 

[daveUK]

Try Forms!MainForm!SubForm.Form.Requery

 

[Dave_cha]

Thanks guys.

I played around with your suggestions and managed to get the following to work;

[Forms]![Main Form]![Subform ctl].form.[Listbox].Requery

Rgd's,

Dave