Making checkboxes and mail merge work in a form.

[soorags]

On a form called frmNz I have added 2 checkboxes, Website? and Email? (i.e. is there a website
and/or email?) I would like it so that if these are selected with ticks then website and email addresses
can be entered into the below textboxes, otherwise the website and email address textboxes
go grey (i.e they cannot be used if they are not ticked) How can I make this possible?

Also I would like a function where I can select companies from the "search results"
subform table and then mail merge letters to them. How is this possible?

Can I add an attachment at all?

Gurdip.

 

[Spenney]

You could set the 'Enabled' property of the text box to 'No' and then use the 'After Update' event of the check boxes to enable the corresponding text boxes when the check box is ticked. Something like...

Private Sub chkWebsite_AfterUpdate()
    If Me.chkWebsite = True Then
       Me.txtWebsite.Enabled = True
    Else:
       Me.txtWebsite.Enabled = False
       Me.txtWebsite.Value = Null
    End If
End Sub

You might need to do something similar with the 'On Current' event of the form to handle the properties of the text box as the current record changes too.

Any good?

 

[soorags]

I get a message whilst trying to disable the control saying:

"You can't disable a control while it has the focus."

Gurdip.

 

[Pampers]

Trying to disable a control that has focus, is not possible. So make sure you are not on the field...

Pampers
Keeping it simple can be complicated

 

[soorags]

It works now. How can I get this to work?
Selecting some companies from the subform and then clicking on a "Mail Merge" command button on the form to perform the Microsoft Word mail merge application with these companies.

Gurdip.

 

[Pampers]

Hi soorags,
So everyone can participate, please post a new thread for the new problem

Pampers
Keeping it simple can be complicated