How do i requery listbox in subform (1 Viewer)

[xwnoob]

Hi,

How do i requery a listbox that is contained inside a subform?

Listfacility is a listbox in main form while the listlender is a listbox in subform.

This is my current code:
[Forms]!
[ListFacility].[Form]!
[ListLender].Requery

 

[tezread]

Check out DoCMD.REquery. You can embed that in one of the fields on the form

see the AfterUpdate() property for the field and code behind that could be DoCmd.Requery

 

[vbaInet]

Is the subform in Datasheet view or a Continuous form?