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


"Turin" <(E-Mail Removed)> wrote in message
news:1DB52D8D-7EC1-4940-8ADF-(E-Mail Removed)...
> 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.
>

This worked. Thank you.

"John Spencer" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:1DB52D8D-7EC1-4940-8ADF-(E-Mail Removed)...
> > 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.
> >
>
>
>