Requerying not working

[Guest]

I have a subform that isn't requery on demand.
The form is connected to a query that is basically created on the fly
I tried adding docmd.requery in the subform onactivate() and in the command
button that triggers the subform.
Looked on the boards for answer but nothing. Please help

 

[Marshall Barton]

I have a subform that isn't requery on demand.
The form is connected to a query that is basically created on the fly
I tried adding docmd.requery in the subform onactivate() and in the command
button that triggers the subform.

If you are constructing the subform's query in code and
setting its RecordSource property on the fly, then there is
no need to requery it. If you are modifying a QueryDef's
SQL property, then that's the long way around, just assign
the SQK statement to the RecordSource property.

To answer your specific question, the syntax to requery the
subform from the main form is:
Me.subformcontrol.Form.Requery
or via code in the subform:
Me.Requery
or, from anywhere:
Forms!mainform.subformcontrol.Form.Requery