insert query problem

[Bobnz]

I have an insert query that inserts to a table that has an autonumber as pkey, the pkey is auto incremented when query runs. I then want to insert that new pkey value in another table. Both these insert queries run off the same button, after the first query runs I need some code or query that will show the new pkey value in a control on the form so I can then take that value and use it in the second insert query.
Hope this makes sense.

B

 

[RoyVidar]

See if this thread contains what you need thread701-931973.

Roy-Vidar