Requery Subform

[Guest_imported]

Can anyone help with the correct VB script to requery a subform?

This is one of the methods that I've tried:-

Form_frmSupplier.Requery
Form_frmSupplier!frmSupplierDetails.Requery

frmSupplier is the main form and frmSupplierDetails is the subform.

This seems very simple, but I cannot get it to work.

Many Thanks

 

[CosmoKramer]

Set the focus on the control in your subform, and Requery that control....

 

[Ouch]

i had this problem before
to refer to a subform you have to use the '.form' operator

this tells Access that the subform control is a form
you can also then refer to controls on that form

eg.

Forms!frmSupplier!frmSupplierDetails.Form.Requery
refers to the whole form

Forms!frmSupplier!frmSupplierDetails.Form![supplier].Requery
refers to a control called supplier on the subform