Easiest way to copy a single record from VB?

[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

 

[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)

 

[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

 

[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

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