'Forwarding' fields from one form to another

From: Turner (anonymous_at_discussions.microsoft.com)
Date: 05/30/04 

Date: Sun, 30 May 2004 15:55:25 -0700

Phil; there are several ways that work. However, I like
this one. On the "On Activate" event of the form that is
being opened place code that looks something like this:

  me.ControlThatYouWishtoPopulate _
    = Forms!TheFormthatDidtheOpening!ControlThatHasTheInfo

Hope this Helps!

>-----Original Message-----
>I've just started using access so forgive this really
>basic question :-)
>
>I am trying to create a database that has 1 main table
and
>4 other tables (and forms for each).
>
>When I enter information into the first form (for the
main
>table), I am setting up command buttons that open the
>other four forms (for the other tables) in order to add
>additional information.
>
>But, I want to 'carry forward' the basic information
from
>the main form/table into the other forms/tables so that
>when the other four forms are displayed, they already
>contain the info from the main form. Further, when I
save
>the data added through any of the other four forms, I
want
>to include the shared fields from the main form (e.g.
the
>primary key in the main table is a foreign key in the
>other four tables amd I don't want to key it in again).
>
>Does this make sense?
>
>I hope so and I hope you can help.
>
>Thanks (in hope)
>
>Phil.
>.
>