How to update subform?

flofi

Registered User.
Local time
Today, 13:14
Joined
Sep 20, 2004
Messages
15
Hi

I've changed the underlying query of a subform. Unfortunately when I use
Forms("mainformName").subformName.Requery
the subform stays empty even if the query shows entries. I don't want to close the form and reopen it.

For the mainform I was able to solve this by renewing the RecordSource Property. But on the subforms this doesn't work.
Forms("mainformName").subformName.RecordSource = "queryName"
--> object does not support property
Forms("subformName").RecordSource = "queryName"
--> form is not found

Do you have any ideas of
- how to update subforms differently?
- how to change RecordSource property of the subforms?

Thanks
 
it's something like
Forms![MainFormName]![SubFormName].Form.RecordSource =
 

Users who are viewing this thread

Back
Top Bottom