Refresh a form

[Neo]

I am trying to reset/requery a form from another form
I am using


Dim frm As Form
Set frm = Forms!SubInvoiceLines1
frm.Requery

but this dones not work it states that it can not find the form

SubInvoiceLines1 is a sub form of frmMainOrder

Thnaks for any help

 

[R. Hicks]

If I understand your question ......

To Requery a form that is not the current form use this example:

Forms![YourFormName].Requery

If you are trying to Requery a subform on a form that is not the current form .. use this example:

Forms![YourFormName]![SubformControlName].Requery

In the above examples .... "YourFormName" is the form to requery.
If Requery is a Subform ... "SubformControlName" should be the name of the "Subform Control" on the form that displays the Subform.

HTH
RDH