Help Statement meeting 2 conditions

[Holli]

Thanks for any help

I am currently trying to make changes to an existing database. One of my task is to have the
user form date box open and highlight only if 2 specific conditions are met.



User selecting Communication Type dropdown box "Marketing Campaign" and checkbox Yes " Ch_dm"

I have written the following code but it is not working correctly. The text box is now defaulting to "Marketing Campaign" and if you select
Ch_dm or "Marketing Campaign" the Date box will open. The only thing that is working correctly is if don't select anything the date box stays grayed out.

I can see the error but cant figure it out. Combining the two.

If Ch_dm = 0 Then
If Communication_Type = "Marketing Campaign" Then
ADQ2_Complete_Date.Enabled = True
Else
ADQ2_Complete_Date.Enabled = False
End If

Holli

[ranman256]

Be sure to use the property: value

ADQ2_Complete_Date.Enabled =Communication_Type = "Marketing Campaign" and Ch_dm.value

[Holli]

Thanks Ranman256

I am confused. Property Value?

[orange]

Holli,

Use code tags when listing your code. Highlight the vba, then click the # above the posting window.
Also shpw all of the code involved.

If Ch_dm = 0 Then '<======This If is an orphan, no end if...
If Communication_Type = "Marketing Campaign" Then
ADQ2_Complete_Date.Enabled = True
Else 
 ADQ2_Complete_Date.Enabled = False
End If

[Holli]

Sorry Orange,

This is the code involved. When I try to remove the If I receive and error message

If Ch_dm = 0 Then 
If Communication_Type = "Marketing Campaign" Then
ADQ2_Complete_Date.Enabled = True
Else 
 ADQ2_Complete_Date.Enabled = False
End If

Thanks

Holli

[Holli]

Thank you! Orange

You saved me.

I have been looking at this all night. crazy person

Holli