Forum Discussion

perrycheng's avatar
perrycheng
Copper Contributor
Dec 22, 2018

Help with Query Criteria

So, I have a value (text) in a form, that was generated from multiple selected list.  e.g. the text box says, 'AB1' or 'CD2' or 'EF3'   

I want to pass this value ('AB1' or 'CD2' or 'EF3') to a query field (e.g. customer).  Well, I can see that the text can come over, but it is not behaving in the criteria section.  I can hand type 'AB1' or 'CD2' or 'EF3'  in the criteria and the query will work, but when drawing the value from the form, it will not filter.  Why?  I did a simple expression, expr1: [Forms]![FormName]![Field] and it display exactly as 'AB1' or 'CD2' or 'EF3' .  Why can't it filter in the criteria??  Help!!  Thanks in advance.

 

Sincerely,

Perry

MS Access 2010
  • perrycheng's avatar
    perrycheng
    Copper Contributor
    Dec 22, 2018

    someone please help.  I thought this is just a brain freeze on my side.  Thank you

    • DanMoorehead_PowerWeb5AI's avatar
      DanMoorehead_PowerWeb5AI
      Iron Contributor
      Dec 23, 2018
      Can you please paste the entire query here as shown in SQL view, along with a screenshot of the results you are seeing in Datasheet view?
      A screenshot of the form you are using for criteria selection / binding may also help provide some context as well.
      • perrycheng's avatar
        perrycheng
        Copper Contributor
        Dec 27, 2018

        TY but I was able to figure it out now.  

Resources