Calling another form

[PeterM]

Here's one I can't figure out.

I have formA and on formA is subFormB. I need to be able to do a requery on
subformB from formC. I can't get it to work, so far I've got the following in
formC:

forms!formA.form.subformB.requery

When formA originally opens it does a query on subformB automatically.
Should I be calling for a requery of formA or subformB?

Thanks in advance for your help!

 

[Allen Browne]

The ".Form" bit is in the wrong place. Try:
Forms!formA!subformB.Form.Requery

That means, requery the form in the subform control named "subformB", on the
form named "formA".

Note that the name of the subform control can be different from the name of
the form it contains (its SourceObject.)

 

[PeterM]

thank you Allen!

The ".Form" bit is in the wrong place. Try:
Forms!formA!subformB.Form.Requery

That means, requery the form in the subform control named "subformB", on the
form named "formA".

Note that the name of the subform control can be different from the name of
the form it contains (its SourceObject.)