Forms

[tonijel]

Hi guys,
can someone tell me please how to create ONE form which will be used for data insert in TWO tables(table A & table B).
Table A has 19 columns & table B has 6 column whit the same name and purpose like some 6 columns in table A.
So through that one form I want to insert data in table A & table B.

thanks for your time

 

[CEH]

If I understand your post ... You have 6 fields in table "B" that are the same as 6 fields in table "A"??? If so, start by deleting table "B" it is not needed. You should not have duplicate information in different tables. (Normally)
Now if you have different info in different tables... ie "A" and "B"... Then do a query using those two tables and base the form on that query.

 

[tonijel]

u R wright.....i was misslead by the fact that those tables where created in excel and used through excel.there is a VBA code in excel table A, which when button pressed copies data from in VBA code specified 6 columns from this file and paste this data in another excel file called table B which contains those data from those 6 columns in table A. Little silly maybe.
The end off this process is that when excel file called table B is updated, i open MS word 2003 an use mail merge option to paste those data from table B.


well the thing is that I tryied to do next:
The data from table B should have been used for mail merge with some word document.....that is why i wanted some unique form, so the users would not have enterning data in table A and than in table B although some data is already inserted in table A(those same columns)
So could I (and what is Your suggestion how to do it) delete table B and somehow implement MS Word mail merge on table A, so that merge include only those 6 columns that where previously in table B.......

thanks again

 

[CEH]

Well, it's confusing to see what your purpose of this DB is. Are Excel, Word, and Access going to be used? Why the final mail merge? Are you sending a report of those six fields out? If your ultimate goal is to send a report,a report to be viewed and not edited, why use mail merge? You can create a report is Access and send it in "snapshot" format. But again, the purpose of your database is not clear.