Combining Conditions Help

[Holli]

I am making changes to an existing Database. One of the requirements is to have 2 conditions that work together.


Either condition by its self works great, but when I try to combine them the database only recognizes the condition written first and not the second. I have tried both ways.

Below is the code that I have written.

1. [CODE]If CH_dm = 0 Then
ADQ2_Complete_Date.Enabled = False
Else
ADQ2_Complete_Date.Enabled = True
End If
[/CODE]

2.[CODE]If Communication_Type.Value = "MarketingCampaign" Then
ADQ2_Complete_Date.Enabled = True
Else
ADQ2_Complete_Date.Enabled = False
End If
[/CODE]

Thanks for any help

Holli

[JoeM]

Where have you placed this code? Is it found in a certain event? We need to know exactly what is calling or triggering this code.

What happens when these two things are in conflict, i.e. what if CH_dm=0 (which says to Disable) and Communication_Type = "MarketingCampaign" (which says Enable)? What is the hierarchy? Which condition wins any conflicts?

[Holli]

The code is placed in the Form Current .
If you select Direct Mail Yes/No Box and the Communication Type "Marketing Campaign" drop down
then ADQ textbox will open. If you don't make this selection the ADQ Textbox should stay closed.

Right now it will stay closed with either code alone. But I need the code to work together. So if Direct Mail and Marketing Campaign are not selected the ADQ Textbox will stay closed.

Thanks

Holli

[JoeM]

Try:

If (CH_dm <> 0) And (Communication_Type.Value = "MarketingCampaign") Then
    ADQ2_Complete_Date.Enabled = True
Else
    ADQ2_Complete_Date.Enabled = False
End If

[Holli]

Yes Thank you so much.

I have one more question. What if I need to add and OR where should I place it?

Again thanks

Holli

[JoeM]

It all depends on the order/precedence of your conditions, but that would go an IF line also (either the same one we have, or a nested IF statement, if necessary).

[Holli]

Everything is working

Thanks again!!!

Holli