Test which Main form a Subform is using

[Cathy]

In Access 2003 have a subform that I am re-using within several different
Main forms. My issue is that I need to put some validation coding on the
subform. (ie. Validate that data in one field on the subform is coordinating
properly with other fields.) Whenever I write this validation code I need to
specify the main form when refering to the fields in the subform. Is there a
way I can test which Main form I am in and then create an if/then statement
to use the correct validation for that Main form?

If you have a different solution, I'm open to suggestions!

Thank you,

 

[Marshall Barton]

In Access 2003 have a subform that I am re-using within several different
Main forms. My issue is that I need to put some validation coding on the
subform. (ie. Validate that data in one field on the subform is coordinating
properly with other fields.) Whenever I write this validation code I need to
specify the main form when refering to the fields in the subform. Is there a
way I can test which Main form I am in and then create an if/then statement
to use the correct validation for that Main form?

The main form can be referenced from any of its child
subforms by using Parent. E.g.

If Parent.mainformcontrol = Me.subformcontrol Then