addnew record

[Guest]

using: access 2003
what to accomplish:
double-clicking on a field (NSN) on a subform (STNDISS) will add that
record to another table (OCIE).
Problem:
the main form (person_frm) contains some data (SSN) that needs to be
added to the same table (OCIE). I don't know how to reference the field (SSN).

I am using .AddNew and .Update. I can get the code to add the record (with
NSN) but the (SSN) is blank.

 

[John Spencer]

Try referencing the control on the main form with the syntax
Assuming the control on the main form is named SSN

[Forms]!Person_Frm!SSN

Or

Me.Parent.SSN

 

[Guest]

This worked. Thank you.

Try referencing the control on the main form with the syntax
Assuming the control on the main form is named SSN

[Forms]!Person_Frm!SSN

Or

Me.Parent.SSN

using: access 2003
what to accomplish:
double-clicking on a field (NSN) on a subform (STNDISS) will add that
record to another table (OCIE).
Problem:
the main form (person_frm) contains some data (SSN) that needs to be
added to the same table (OCIE). I don't know how to reference the field
(SSN).

I am using .AddNew and .Update. I can get the code to add the record (with
NSN) but the (SSN) is blank.