Copying a Record (1 Viewer)

[Topher]

I'd like to know if its possible to copy an entire record within the same table.

ie in table1 i have a record with 10 fields - the first being the primary key - an ID field

i'd like to copy that record and create a NEW record with all the same information. I thought it would be easy to do with an append query and not include the primary key field so that it is then created automatically when the new record is appended.
however i keep receiving errors when i do this.

i have other tables linked to this table but they dont require any information from this table as it is the main table of the db - this table has ids from the others which im copying...

any ideas on this? i would prefer a query rather than VBA but that would work as well.

or perhaps i have to copy the record i want into a temp table and then append that record into the real table??

thanks!

- Topher

 

[Jack Cowley]

If you are using a form and you want the previous record copied to a new record when the user moves to a new record then this article will show you how to do it....

http://support.microsoft.com/suppor...0236&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

 

[Topher]

Thanks that will help also - actually i was able to do it with the query - i realized i had forgotten to include a field that was required - thats why i was getting the error i was getting.

thanks!

- T