Open a second form but link to the original

[JZ]

I have a form (frmClassInfo) that contains ClassID, Name,
Class Date, etc.
I want to open a second form (frmEvaluation) from this
screen & allow the user to enter an evaluation for the
class. If the user is looking at frmClassInfo how do I
open up the evaulation form and have the ClassID field
automatically be entered (classID is a field in
tblEvaluation so the relationship is created). Is a macro
the best way to make this happen? If so do you have any
tips on how the macro should be written I am really new at
writing them.

Thanks!!!!!

Jill

 

[tina]

try putting a macro in frmEvaluation's BeforeInsert event or BeforeUpdate
event, as

Condition: ClassID Is Null
Action: SetValue
Item: [Forms]![frmEvaluation]![ClassID]
Expression: [Forms]![frmClassInfo]![ClassID]

i understood you to say that both tables have a field named ClassID. if not,
you need to change the field name(s) above to the appropriate name(s).

hth