Control Group Question

K

KarenMike

I have a table that contains member address and I have a table using
recipient addess. These tables are linked via member number. I currently have
the database linked to a mail merge in word. I have set up an option button
in my form and asks which address I want my letter to be sent. Would I then
set up a query to link to my mail merge and if 1 use member information and
if 2 use recipient information? I am a novice when it comes to writing code,
so any help on the code or any better option would be of great help
 
A

akphidelt

Im not experienced at mail merges, but it seems like you are. The only thing
I can think is to create a text box, you can even turn off it's visibility...
but use that text box with an IIF statement as it's control source... i.e.
IIF(optiongroup=1,textbox1,textbox2)

Then just link the mail merge to that dummy text box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top