Copy data to other table

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I had a Form (called Form A) including a sub-form Form B, that link to table
A & B.
User will input some data in Form [A+B].

As other table also need some of the data in [FormA+B]/ Table A&B.
How can I copy those fields (data) to other table C,D.....?

Add a command button, Query or use VBA ?

Thx !
Joe
 
Also, my user don't want to prompt any message box for them to click when
insert/copy data to other table......
Thx !
 
I had a Form (called Form A) including a sub-form Form B, that link to table
A & B.
User will input some data in Form [A+B].

As other table also need some of the data in [FormA+B]/ Table A&B.
How can I copy those fields (data) to other table C,D.....?

Add a command button, Query or use VBA ?
Click to expand...

Well... DON'T.

Access is a relational database. One very basic principle of
relational databases is that you store data ONCE, and once only, and
then look it up using Queries.

A Select query joining TableA to TableB, and including whichever
fields you want to see, can be used as the recordsource for a Report;
for another form; for export to a text file, spreadsheet, or email; as
the basis for another query. You will very rarely gain ANY benefit by
storing the data redundantly in Tables C or D.
 
So can i use variable to store the value and then insert/copy to other
table?

Thanks.
Joe

John Vinson said:
I had a Form (called Form A) including a sub-form Form B, that link to table
A & B.
User will input some data in Form [A+B].

As other table also need some of the data in [FormA+B]/ Table A&B.
How can I copy those fields (data) to other table C,D.....?

Add a command button, Query or use VBA ?
Click to expand...

Well... DON'T.

Access is a relational database. One very basic principle of
relational databases is that you store data ONCE, and once only, and
then look it up using Queries.

A Select query joining TableA to TableB, and including whichever
fields you want to see, can be used as the recordsource for a Report;
for another form; for export to a text file, spreadsheet, or email; as
the basis for another query. You will very rarely gain ANY benefit by
storing the data redundantly in Tables C or D.
Click to expand...
 
Back
Top