Easiest way to copy a single record from VB?

M

Max Moor

Hi All,

Assume I have a recordset handy, and I'm looking at a record I want to
copy. What is the simplest way?

In the past, I've used AddNew, then copied contents field by field. Is
there a better way?

Thanks, Max
 
M

Matt

You can highlight the entire record by clicking to the left of the first
field. Copy the entire record. Then go to the end of the recordset and paste
the enitre record in the last row (last row will always be blank)
 
J

Jeff Boyce

Or, if you are working in VB/code, you could:

Select the record
Copy the record
Paste/append the copied record

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
M

Max Moor

Or, if you are working in VB/code, you could:

Select the record
Copy the record
Paste/append the copied record

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...

Hi Jeff,

Vb is where I am. How are the select, copy, and paste/append done in
VB? I don't see methods on the recordset object that let me do those things.

- Max
 
Top