addnew record

T

Turin

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.
 
J

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
 
T

Turin

This worked. Thank you.

John Spencer said:
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


Turin said:
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.
Click to expand...
Click to expand...
 
Top