Select Criteria from a Form to a Parameter Query using 'like'

L

LoriO

Is it possible to have a form that populates a query to open a Report if the
file on the query needs to have the form response be 'like'
EX:
Field on Form: cboSelAssign
Field on Query: value of field can be a;b;c
I want the selection criteria to be Like [cboSelAssign] not Equal to

So if the value of cboSelAssign is "b" I will get the record where the field
is = "a;b;c"
Is this possible
 
T

tw

You don't want to use like use something like instr

one example could be

in the criteria of your query put
InStr(YourField, forms!frmYourForm!cboSelAssign) > 0
 
L

LoriO

Thank You!! I did not think of this and it worked!

tw said:
You don't want to use like use something like instr

one example could be

in the criteria of your query put
InStr(YourField, forms!frmYourForm!cboSelAssign) > 0

LoriO said:
Is it possible to have a form that populates a query to open a Report if
the
file on the query needs to have the form response be 'like'
EX:
Field on Form: cboSelAssign
Field on Query: value of field can be a;b;c
I want the selection criteria to be Like [cboSelAssign] not Equal to

So if the value of cboSelAssign is "b" I will get the record where the
field
is = "a;b;c"
Is this possible
Click to expand...
Click to expand...
 
Top