Referring to A Subform field

P

PhilipBenno

I Have a main form with a subform.When I Am sat on a Field on the mainform on
the got focus event I'am wanting to reference a field on the subform is this
possible anybody????
 
P

PhilipBenno

Hello Dennis Whats the actual command my subform is callled ML - Final Audit1
Subform and my field is called FA1 - Piercing Top X R1 Diff

Thanks
 
D

Dennis

Forms![ML - Final Audit1 Subform].Form.[FA1 - Piercing Top X R1 Diff]

At the end of the above line, if required you can then use .Text or .Name
etc. to reference the properties of the field on the sub form.
 
P

PhilipBenno

Thanks Very Much for yor Help

Dennis said:
Forms![ML - Final Audit1 Subform].Form.[FA1 - Piercing Top X R1 Diff]

At the end of the above line, if required you can then use .Text or .Name
etc. to reference the properties of the field on the sub form.

PhilipBenno said:
Hello Dennis Whats the actual command my subform is callled ML - Final Audit1
Subform and my field is called FA1 - Piercing Top X R1 Diff

Thanks
Click to expand...
Click to expand...
 
B

Bruce D.

Philip,
Are you from Ohio?

Bruce D.

PhilipBenno said:
Thanks Very Much for yor Help

Dennis said:
Forms![ML - Final Audit1 Subform].Form.[FA1 - Piercing Top X R1 Diff]

At the end of the above line, if required you can then use .Text or .Name
etc. to reference the properties of the field on the sub form.

PhilipBenno said:
Hello Dennis Whats the actual command my subform is callled ML - Final Audit1
Subform and my field is called FA1 - Piercing Top X R1 Diff

Thanks

:

Use Forms!SubFormName.Form.FieldName

:

I Have a main form with a subform.When I Am sat on a Field on the mainform on
the got focus event I'am wanting to reference a field on the subform is this
possible anybody????
Click to expand...
Click to expand...
Click to expand...
 
Top