Copy current record from Access to Excel

[surfacesys]

What is the easiest way to copy the current record from Access to Excel?

My Access form has a sub form also, so I can't just copy and paste easily.

Any ideas?

Michael

 

[snyperx3]

DoCmd.TransferText is something I like to mess with.


-Pete

 

[surfacesys]

How and where should I do this? I am very, very green when it comes to coding.

While in the form and on the current record.... I do what???

create a button maybe?
Then OnClick
then coding
then enter DoCmd.TransferText
then do I paste on the excel side of things??

Thank You,
Michael