Take current record from one form and Print to another form

[mwojo]

I would like to create a Command Button to take the current record that I am viewing in one form and print it out using another form.

TIA

Micheal

 

[Rolliee]

If the field names are the same, you can use code like this.

dim ar(20) as variant

for i = 0 to 19
ar(i) = me.fields(i)
next i

use the docmd.openform ??..' check these out w/ the wizard
docmd.???record acNewRecord

for i = 0 to 19
me.fields(i) = ar(i)
next i

rollie@bwsys.net

then to a