Forum Discussion

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 quer...

MS Access 2010

perrycheng

Copper Contributor

Dec 22, 2018

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

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
Copper Contributor
Dec 27, 2018
TY but I was able to figure it out now.
- DanMoorehead_PowerWeb5AI
  Iron Contributor
  Dec 31, 2018
  perrycheng,
  
  Great, I'm glad to hear you worked it out.
  
  Best regards,
  Dan
  
  Dan Moorehead
  Chief Software Architect
  PowerAccess (https://www.PowerAccess.net – All-in-One Toolset ● Framework ● Consulting for Microsoft Access
  CrushErrors Data Prep AI (https://CrushErrors.com) – AI-powered Data Prep ● Reporting ● Finance ● Compare ● Merge for Excel Add-in ● Embedding ● Cloud
  https://www.PowerAccess.net | https://www.linkedin.com/in/DanMoorehead/ | https://twitter.com/PowerAccessSQL | https://www.facebook.com/DanLMoorehead