Inputting data Text box to several tables

[northernbreaks]

I am trying to link the textboxes on a form so that their values are stored in 2 seperate tables.
Setting the Record Source of the Form to TableA and the various Text boxes etc are set to the Fields in that table works fine, however I want some other text boxes to be linked to another set of table fields, so that when I enter values into those text boxes the data ends up in a different table.

Has anyone any ideas on how text boxes on one form can be linked to different tables.


dave

 

[supercharge]

You might want to store those textboxes values as global variables then run some update SQL statements (or insert or append, whatever appropriate) to add them to as many tables as you'd like.

 

[DarkProdigy]

Could you add something to the control source like an "&" or some such so that it does this? I'm really new to Access so I could be horribly wrong but it seems to me there should be an easy way to link them.

 

[geraldcor]

I believe you can just create a query that has the multiple tables in the query. Then base your form on the query and it will add the data into the appropriate fields in the appropriate table.