Need help copying when using a tab control.

[jasonmac]

Hello everyone. I'm using access '97 for this.
I have a form that uses a tab control to display a large amount of data. Sometimes 2 records, due to customer requests for quotes, are very similar. To save time for the users and eliminate reentering data I am trying to allow the user to copy and paste a record. I used the following code in some testing.

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend

This works great and the autonumber is automatically incremented so there are no duplicate records. However when I try to use the above code on a form with a tab control I get a warning stating that no all the information will be copied and when I continue only the information on the first tab is copied. Can anyone suggest an way around this or even another way of accomplishing my goal?

Thanks in advance,
Jason

 

[PHV]

Take a look at RecordSet

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jasonmac]

Could you be a little more specific? Could anyone explain?

 

[jasonmac]

*Bump