Transfer Text Issue

[WayneRyan]

Doreen,

No problem, sorry I didn't make the form look a little better.

You can also make a query and use that as your recordset, instead of
referencing the table(s). Just design a query, save it, and use that name
in your .OpenRecordset command.

Wayne

 

[dakcg]

I am still an Idiot!

Hi Wayne, sorry to bother you again, but I used your code- which worked great the way you wrote it- and I added an extra rst(changing it to rst1) to be sent out. it didn't work. Is there anything extra I need to do to add more than one rst?
Sorry for being such a bother, but I am totally clueless with code. But I am trying to learn!
I thank you for your continuing patience!

Doreen

 

[WayneRyan]

Doreen,

Give me a minute here.

Wayne

 

[WayneRyan]

Doreen,

I added a new query for you: qryForPrint

I just added the beneficiary table (and a John Smith record).

In your Module5, look at the open recordset (it uses the query) and
the code at the end is where you can reference the new fields that
the query introduces.

Experiment with it,
Wayne