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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
Query Parameter using multiple options 0
Access Dcount (multiple criteria) 3
Using Like and # in query criteria 3
Use Parameter Form to export a query 3
Multiple criteria in a parameter query 5
query criteria from form 7
Setting criteria in query 2

Back
Top