Requery subform question

S

SHIPP

I have two forms (form A and form B) I have a subform on form A.
How would I requery the subform on form A if I am on form B. The following
gives me an error

Forms.formA.formAsubform.Form.Requery
 
S

Stuart McCall

SHIPP said:
I have two forms (form A and form B) I have a subform on form A.
How would I requery the subform on form A if I am on form B. The following
gives me an error

Forms.formA.formAsubform.Form.Requery

Try:

Forms!formA!formAsubform.Form.Requery

Use bang (!) to refer to a member of a collection, and dot (.) to refer to
properties or methods of an object. Forms is a collection. formA is a member
of that collection while it's open.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top