how do I set up a text box on a form to output to multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone

I was just wondering if it would be possible at all to link up a text box on
a form to input data to multiple fields, these being in separate tables all
within the same database?

So far I have found out that I need to click on the text box whilst the form
is in 'design view' and then right click the text box in order to locate the
properties for the text box. Then go to the data tab to find the control
source option and navigate to the build option but from there I am rather
lost on how to build the function to select the multiple tables.
 
Right click in the window and select "show table." Note that you should
make sure that these tables all have some logical relationship, or you might
make a big mess trying to do it this way. If you don't have relationships
defined in the relationships window, you should drag and drop the fields in
the query to create relationships in the query.

HTH;

Amy
 
Jarrett said:
Hi everyone

I was just wondering if it would be possible at all to link up a text
box on a form to input data to multiple fields, these being in
separate tables all within the same database?

So far I have found out that I need to click on the text box whilst
the form is in 'design view' and then right click the text box in
order to locate the properties for the text box. Then go to the data
tab to find the control source option and navigate to the build
option but from there I am rather lost on how to build the function
to select the multiple tables.
Click to expand...

A form is bound to exactly one RecordSource and a control on the form can
only be bound to a single field in that RecordSource. Anything else that
you need to happen you will have to do with code.
 
Back
Top