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
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