Access- Copying Records across

OK.. I have a database in Access 97. and it does everyting thing I want. the one thing I am having problems with is copying one record onto another. is this possible. the format of the database is as follows

you choose a customer. which will allow access the the subform on the same page call ordermain. with the key being order number. in this subform there will be details regarding an order , ie. date, contact etc. this will also have a subform linked via the ordernumber 1 to many ratio. called orderdetails on this subform you will have various items which are the main quote. what I would like to do if possible is copy the orderdetails subform onto a new record. how can I do this?

Also when I am using the orderdetails subform I have 4 boxes, item no. price description and qty. in the item no. I currently pu inthe number 1, 2,3 etc manually is there a automagic way of the database auto numbering the items in relation to the number of itmes I have on the subform.

Fuew thanks

 

I don't know what you mean by "copying the record"--i.e. where you want it to go. Should be as simple as running an append query with the appropriate criteria set, then maybe requerying the subform if you're trying to do it with the subform open.

As for setting the number automatically, you can use the BeforeInsert event of the form--this will not show on the form until the record is saved, but it will work correctly, together with the DMax() function, the appropriate criteria (ordernumber=x), and a + 1.

I'd suggest doing a little reading in Access help on append queries and DMax as a place to start. And you will have to be able to write (simple) macros to do it, so if you aren't familiar with them you should spend a little time learning about them in help.