Getting information on one form to appear on another form

  • Thread starter Thread starter MIchael
  • Start date Start date
M

MIchael

I'm building my first data base in Access and my Access
Bible is not very specific on how to share information
between forms AFTER you have created them. The two data
tables that make up the two forms are related via a link
in the Relationships window. I thought by labeling
fields in the second table with the same name as those
that I wanted to share from the first table, the data
would just appear being that the two tables are linked.
Iwas wrong. MyAccess Bible is pretty clear on how to join
two forms with a query and then make a subform and drag
everything you want to share from the query to the
subform. However, there must be a simple way to grab my
customer name and address from one form and make it
appear on my second related form without creating a third
subform. Can anyone tell me how to do that?

Thanks
 
Firstly officially a form is not linked to another form,
it is the tables which are linked together. I am assuming
that are are creating a sales database or something
similar, usually I would recommend using a form wizard to
make the form which will pull out the fields you choose
from different tables. Altenativly you could try creating
the text boxes in the design view from the toolbar and
then going into the properties box and in the control
source bit you can click the ... on the right and select
expression builder, from there you may select the fields
in the table. Of course for some bits of the form you may
wish to use the subform
 
Back
Top