subform field referrence

S

spanky

i have a ? regarding syntax. I have Form123 with several
tabs all containing subforms. In the Jan tab there is
subformA with fieldA in the footer (sum calc). i am
trying to get fieldA's info to the summary tab in
subformB. i keep getting an error ?Name. please advise.
thanks.
 
R

Ragnar Midtskogen

The syntax for referring to a control on a subform is;
Forms!MainFormName!SubformName.Form!SubformControlName
This and a lot more is available through Access help menu.

Ragnar
 

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

Please Help!!! Macro required to select new record in Subform 0
Sending Data from One subForm to another 8
subform to subform 3
subforms not requerying 6
An odd =Sum() question? 20
Unable to delete subform records 11
Tab order in sub form 3
Creating Top 10 in linked subform 1

Top