S
Steve Ketchum
I have on a form three option boxes. opt1,opt2,opt3. in a
module i read the selection and create a criteria like
such:
public function test()as string
dim frm as form
set frm = etc.
select case frame1 'options reside inside frame
case opt1
test = "A"
case opt2
test = ""
case opt3
'this is what i would like to see happen
test = "Like *"
end select
end function
I have always been able to pass a single value to a query
but the 3rd option fails. Can you pass multiple options
or a string value other than a single value. Is there a
way of passing a "between and" statement of how about a
value using or(ex. 123 or 456 or 999).
Your help is greatly appreciated.
Steve
module i read the selection and create a criteria like
such:
public function test()as string
dim frm as form
set frm = etc.
select case frame1 'options reside inside frame
case opt1
test = "A"
case opt2
test = ""
case opt3
'this is what i would like to see happen
test = "Like *"
end select
end function
I have always been able to pass a single value to a query
but the 3rd option fails. Can you pass multiple options
or a string value other than a single value. Is there a
way of passing a "between and" statement of how about a
value using or(ex. 123 or 456 or 999).
Your help is greatly appreciated.
Steve