Referring to A Subform field

[Guest]

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????

 

[Guest]

Use Forms!SubFormName.Form.FieldName

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

Thanks Very Much for yor Help

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.

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

 

[Guest]

Philip,
Are you from Ohio?

Bruce D.

Thanks Very Much for yor Help

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.

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????