i have to believe i'm misreading this code, somehow. when
i watch chkboolean.value, it changes to false, as it should,
the first time the code is run through. but then when
it runs through a second time, this code should NOT
get triggered, because now chkboolean.value=false (which
it shows, correctly, in the watch window).

xxxxxxxxxxxxxxx

If chkBoolean.Value = True And _
optCouponsOnly.Value = True Or _
optSchedCoupons.Value = True Then
MultiPage1.pgCoupons.Visible = True
chkBoolean.Value = False
MultiPage1.Value = 1
txtProgID.SetFocus
MsgBox "Please also fill in these fields, then press ""Continue""."
_
, vbInformation, "Let's see................."
Exit Sub
chkBoolean.Value = False
End If

xxxxxxxxxxxxxxx

thanks for any assistance.
susan

duh... forget to say what the PROBLEM is.......
it keeps repeating thru this msgbox & won't
actually continue.

Susan wrote:
i have to believe i'm misreading this code, somehow. when
i watch chkboolean.value, it changes to false, as it should,
the first time the code is run through. but then when
it runs through a second time, this code should NOT
get triggered, because now chkboolean.value=false (which
it shows, correctly, in the watch window).

xxxxxxxxxxxxxxx

If chkBoolean.Value = True And _
optCouponsOnly.Value = True Or _
optSchedCoupons.Value = True Then
MultiPage1.pgCoupons.Visible = True
chkBoolean.Value = False
MultiPage1.Value = 1
txtProgID.SetFocus
MsgBox "Please also fill in these fields, then press ""Continue""."
_
, vbInformation, "Let's see................."
Exit Sub
chkBoolean.Value = False
End If

xxxxxxxxxxxxxxx

thanks for any assistance.
susan

from the immediate window:

? false and true or true
True
? false and (true or true)
False

so why struggle. Use parens to make your intent clear.

why is it a problem - evaluating from left to right it would look like

(false and true) or true
(false and true) becomes false so the second evaluation is False or True

--
Regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy


"Susan" wrote:

duh... forget to say what the PROBLEM is.......
it keeps repeating thru this msgbox & won't
actually continue.

Susan wrote:
i have to believe i'm misreading this code, somehow. when
i watch chkboolean.value, it changes to false, as it should,
the first time the code is run through. but then when
it runs through a second time, this code should NOT
get triggered, because now chkboolean.value=false (which
it shows, correctly, in the watch window).

xxxxxxxxxxxxxxx

If chkBoolean.Value = True And _
optCouponsOnly.Value = True Or _
optSchedCoupons.Value = True Then
MultiPage1.pgCoupons.Visible = True
chkBoolean.Value = False
MultiPage1.Value = 1
txtProgID.SetFocus
MsgBox "Please also fill in these fields, then press ""Continue""."
_
, vbInformation, "Let's see................."
Exit Sub
chkBoolean.Value = False
End If

xxxxxxxxxxxxxxx

thanks for any assistance.
susan

success! thanks.... i didn't know i could use the parentheses to
make the intent clear..........
as far as i could see i had it written correctly
but it wouldn't work.
xxxxxxxxxxxxxx
If chkBoolean.Value = True And _
(optCouponsOnly.Value = True Or _
optSchedCoupons.Value = True) Then
MultiPage1.pgCoupons.Visible = True
chkBoolean.Value = False
MultiPage1.Value = 1
txtProgID.SetFocus
MsgBox "Please also fill in these fields, then press ""Continue""."
_
, vbInformation, "Let's see................."
Exit Sub
End If
xxxxxxxxxxxxxxxxxx
i was throwing "chkBoolean.Value=False"'s everywhere
to try to make it work! ha ha
thanks again for your kind assistance!
susan


Tom Ogilvy wrote:
from the immediate window:

? false and true or true
True
? false and (true or true)
False

so why struggle. Use parens to make your intent clear.

why is it a problem - evaluating from left to right it would look like

(false and true) or true
(false and true) becomes false so the second evaluation is False or True

--
Regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy


"Susan" wrote:

duh... forget to say what the PROBLEM is.......
it keeps repeating thru this msgbox & won't
actually continue.

Susan wrote:
i have to believe i'm misreading this code, somehow. when
i watch chkboolean.value, it changes to false, as it should,
the first time the code is run through. but then when
it runs through a second time, this code should NOT
get triggered, because now chkboolean.value=false (which
it shows, correctly, in the watch window).

xxxxxxxxxxxxxxx

If chkBoolean.Value = True And _
optCouponsOnly.Value = True Or _
optSchedCoupons.Value = True Then
MultiPage1.pgCoupons.Visible = True
chkBoolean.Value = False
MultiPage1.Value = 1
txtProgID.SetFocus
MsgBox "Please also fill in these fields, then press ""Continue""."
_
, vbInformation, "Let's see................."
Exit Sub
chkBoolean.Value = False
End If

xxxxxxxxxxxxxxx

thanks for any assistance.
susan