I need some help with Forms fast....

T

teelee

I have 3 tables and 3 forms, what I want to do is after I open the first form
and go to the second form I need the first field to be connected to the other
2 forms. That is just the first tab in my main form. When I open the other 2
forms I want to automatic have the first field filled with the information
that's in the 1st field. It's paln name and the other 2 forms also have plan
names so I just made it on the first form.

Thanks
 
U

UpRider

Teelee,
There may be some problems doing what you want to do.
If the second (or third) form displays existing table data when you open it,
the existing plan name will be instantly obliterated with the plan name on
the first form. Is that what you want?

UpRider
 
T

teelee

What I want to happen is...I have 3 tables and 3 forms the only reason why I
set it up this way is because the Plan Name is on all 3 forms and tables.
What I would like to happen is when i'm in the first form then go to the
other 2 forms I would like for the Plan Name to be populted in the Plan Name
field. Is this possible?

Thanks
 
R

Rick Brandt

teelee said:
What I want to happen is...I have 3 tables and 3 forms the only
reason why I set it up this way is because the Plan Name is on all 3
forms and tables. What I would like to happen is when i'm in the
first form then go to the other 2 forms I would like for the Plan
Name to be populted in the Plan Name field. Is this possible?
Click to expand...

Use subforms. Otherwise you would have to run code that would insert data
into the other tables. And it would only be appropriate to do this when you
are actually entering data into the OTHER fields as well in the second and
third tables. Creating blank "dummy" records is definitely NOT a good idea.
 
T

teelee

Can I use 2 subforms in my main form? Also, how would I populate the Plan name?

Thanks
 
R

Rick Brandt

teelee said:
Can I use 2 subforms in my main form?
Yes

Also, how would I populate the Plan name?
Click to expand...

Properly set up subforms would do that automatically. The MasterLink and
ChildLink properties of the subform control do that for you.
 
Top