Getting data from another form to display in header on main form.

[the_net_2.0]

Just to clarify, I'm talking about the .Form reference, not the Forms!

What version of Access have you seen this not working?

i don't know. i've never tried it out. just always done it. subform controls are always followed by ''.form'' if you want to treat it like one

 

[vbaInet]

Then maybe you should try it out

.Form is a must if you're referring to the form's property like RecordsetClone or RecordSource (for example).

 

[the_net_2.0]

Then maybe you should try it out

.Form is a must if you're referring to the form's property like RecordsetClone or RecordSource (for example).

I will do that sometime! thanks bud!

back to the OP's purpose of this, if it's not already solved, that is.

 

[CBrighton]

I use access 2003 and I'm self trained.

If i use the .Form (which I do) it's because I tried it without and it didn't work so I had to google how to get it working.

However that could have been in VBA code doing something completely different, it may be that it works fine directly in Access but VBA needs the .Form

 

[vbaInet]

An example for you guys.

Created in 2000.
Tested in 2000, 2003 & 2007

Have a look at frmTest.

NB: =[SubformControl].[ControlName] or =[SubformControl].[FieldName] will not work, but =[SubformControl]![ControlName] or =[SubformControl]![FieldName] will.