Simple copy values question.

[Celia]

Hi everyone:

I have been a reader for a long time and have learned alot, however I still
feel that I am newbie at this.

Quick question. I have a form named FormA with a Loc_ID field. I have a
subform FormB linked to FormA form via Loc_ID. Subform FormB has a button
that when clicked it opens a subform FormC with information from Tag_N which
currently exists in FormB I would like to add a button that changes the
Loc_ID currently displayed in FormC to the existing value in Loc_ID in FormA.

I am not sure about the syntax but the main idea is this:
FormC[Loc_ID]=FormA[Loc_ID].

What is the correct way or the correct syntax to approach this with? Any
help is soooo appreciated.

Celia

 

[John W. Vinson]

I am not sure about the syntax but the main idea is this:
FormC[Loc_ID]=FormA[Loc_ID].

Forms![FormC]![Loc_ID] = Forms![FormA]![Loc_ID]

Just one concern: you're focusing on Forms here. Be sure you're aware that
forms *are secondary* - data is *NOT* stored in forms; they're just windows,
tools to get data into and out of Tables. In particular, there are no
"relationships" between Forms; Tables have relationships, and forms can (but
need not!) follow those relationships.

John W. Vinson [MVP]

 

[Celia]

I am not sure about the syntax but the main idea is this:
FormC[Loc_ID]=FormA[Loc_ID].

Forms![FormC]![Loc_ID] = Forms![FormA]![Loc_ID]

Just one concern: you're focusing on Forms here. Be sure you're aware that
forms *are secondary* - data is *NOT* stored in forms; they're just windows,
tools to get data into and out of Tables. In particular, there are no
"relationships" between Forms; Tables have relationships, and forms can (but
need not!) follow those relationships.

John W. Vinson [MVP]

Hi John:

Thanks for responding. I understand about the relationships in tables etc.
I have a background in SQL and Oracle, but the Microsoft Access Interface is
a bit difficult for me to grasp. Your help solved my problem, thank you so
much for your help John. I really appreciate it and have a great weekend.

Celia