Copy Data From One Table To Another

[jimbohodge]

Hi,
I need to know how to use a Macro to be able to:
- When a new record is entered into a form, it will not only add the record to that table but also add the exact same record to another table.

I know it can be done, but i havent a clue.
Any ideas?

Jim

 

[jeremypaule]

use an append query

 

[jimbohodge]

It dont loook like an append query is going to work with mine.
Is there any way of creatig a macro that will copy & past the data into the other table?

Jim

 

[Dreamweaver]

An Append query will work once your data is added you can grab the new entrys ID then use that in the append query all you need to if make sure the query runs brfore a user can move to a new row.

You could use OnDirty To Get the ID when data if added to the form then use that value to send to the query before the focus is moved to a new record.

Before update would be the best place to put it but you need to make sure the user has completed the entry and not just saved it half way through.

Mick

 

[jimbohodge]

Hi,

Thanks for your Help.
I'm not very experienced with Access so please bear with me.
I think the reason i cnt get it working may be due to the fact that the form where the data is being entered ha fields ranging from two dfferent tables.

I have attatched the file if you think you could please have a look at it.

As you can see, its for a 5 a-sde football company.
I have had two create two Team tables and Two Manager Tables.
New team and new manager details are etered into Tables Team1 and Manager1 through the 'NEW_Team' form. I would like it to be able to automatically add the same data into tables Team2 and Manager2.

Thanks
Jim

 

[Dreamweaver]

I will have a look and see what I can do just in the middle of some complex File Functions As The Moment hopefully tomorrow or maybe someone will beat me to it.


mick

 

[jimbohodge]

Ok, Cheers.

Look forward to hearing from you.

Thanks

Jim