How could I use two similar criteria in one if... then block? for example
if textbox1.value = "A" or "A1" then...
docmd bla bla
Thanks.
How could I use two similar criteria in one if... then block? for example
if textbox1.value = "A" or "A1" then...
docmd bla bla
Thanks.
or:Code:if something then if something else then BOTH TRUE end if ONLY FIRST 1 TRUE end if
or:Code:SELECT CASE myCriteria case is something do something case is somethingelse do something else case else do something that doesn't match any cases END SELECT
Code:if something then do something elseif do something else elseif do something else, but not the above 2 things else do something that doesnt match the above 3 end if
if textbox1.value = "A" or textbox1.value = "A1" then
Thanks Adam, my code is a little long to reuse it, so I was looking for something more compact
@ Paul, thanks a lot that what I was looking for. great solution!!!
thanks a lot again guys!!!
Happy to help avworx.
Sorry Adam...NOT!