Linking fields on subforms

[ohappyday]

Hi -

I have 2 subforms (sub 1 and sub 2). I would like to link a field that is populated on sub 2 and have the value appear in a read only field on sub 1).

How can I do this?

Thanks!

 

[John Big Booty]

This link should help you formulate the correct syntax for referencing subforms and their controls.

 

[smig]

rowsource for the field on form 1:
Forms![TopForm]![SubForm2].Form![FiledName]

for the Sub2 Field's after update event:
Forms![TopForm]![SubForm1].Form![FiledName].refresh

 

[ohappyday]

Thanks for your help.

I keep getting #Name? in the field on Subform 1. I am using 2007, is rowsource actually control source in 2007?

 

[John Big Booty]

Thanks for your help.

I keep getting #Name? in the field on Subform 1.

........

The #Name? error indicates that Access is unable to resolve the reference you have given that control. ie. it is unable to find the control you are referring to.

......

I am using 2007, is rowsource actually control source in 2007?

Correct it should be Control Source.

 

[ohappyday]

Thanks!! I tried the solution this week and it worked!!

Thanks so much!!!!!

 

[John Big Booty]

Glad to hear you got it sorted