addnew record

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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...
 
Back
Top