FORM

R

Ransom

Hi,
Me again....I am trying now to have my subform linked with my main form.

However I only want the First and Last Name of the person to show on the
subform....what I have is about 4 of those tabbed pages.....so on page 1 if
you input the First and Last Name of someone.....Id like for it to show on
page 4 in the subform......I sure hope that makes sense.....

Essentially, I'd just like the form to update itself with information that
is inputed from someplace else.....please help.....Im fried with this one.....
 
J

John W. Vinson

Hi,
Me again....I am trying now to have my subform linked with my main form.

However I only want the First and Last Name of the person to show on the
subform....what I have is about 4 of those tabbed pages.....so on page 1 if
you input the First and Last Name of someone.....Id like for it to show on
page 4 in the subform......I sure hope that makes sense.....

Essentially, I'd just like the form to update itself with information that
is inputed from someplace else.....please help.....Im fried with this one.....
Click to expand...

It sounds like you're confusing forms with tables.

Data is stored in tables, and only in tables. It makes absolutely NO
difference where or what kind of form is used to enter the data into that
table. If it's in the table, it will be displayed.

What is the Recordsource of your form? Of the Subform? Are you trying to link
on first and last name - if so, what will you do if there happen to be two
people who have the same name? (I know three men named Fred Brown).

John W. Vinson [MVP]
 
R

Ransom

I think I confused you...;).......I do have the tables set up
correctly......but you know how an autoform is designed....like if you select
apples....the price, where they are located may automatically come up? Well,
Id like the subform to automatically put the name of the person from the main
form...so that the name stays linked with a particular person.....for
example...John Stewart is the foster parent to Michael, Edward, and James and
the subform would have Johns name and all the pertinent information related
to Michael, etc.. al......does that make better sense...
 
J

John W. Vinson

I think I confused you...;).......I do have the tables set up
correctly......but you know how an autoform is designed....like if you select
apples....the price, where they are located may automatically come up? Well,
Id like the subform to automatically put the name of the person from the main
form...so that the name stays linked with a particular person.....for
example...John Stewart is the foster parent to Michael, Edward, and James and
the subform would have Johns name and all the pertinent information related
to Michael, etc.. al......does that make better sense...
Click to expand...

I'm leaving momentarily on a week-long trip so maybe you should start a new
thread. Just make sure that the Master/Child Link Field properties are
correct; and/or put a textbox with a control source

=Parent!FirstName

on your subform.

John W. Vinson [MVP]
 
J

Juan sanchez

78

Ransom escribió:
I think I confused you...;).......I do have the tables set up
correctly......but you know how an autoform is designed....like if you select
apples....the price, where they are located may automatically come up? Well,
Id like the subform to automatically put the name of the person from the main
form...so that the name stays linked with a particular person.....for
example...John Stewart is the foster parent to Michael, Edward, and James and
the subform would have Johns name and all the pertinent information related
to Michael, etc.. al......does that make better sense...

:
Click to expand...
 
Top