Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1946
  • Last Modified:

MS Access Query Criteria Text Box

Hi Experts

I am using a query in ms access. The query takes its criteria from a text box on a form using
Criteria:
[Forms]![frmMainMenuUser]![txtViewCallsQrySource]

However, even though I am sure there are values in the table that match the criteria,
the query is returning no results. Has anyone experienced this problem before, or know
how to fix it? Thanks in advance.
0
paganji
Asked:
paganji
3 Solutions
 
peter57rCommented:
I think you can be sure the query is working correctly.
Almost certainly you have a data issue.
Are you using matching against a lookup field by any chance?
0
 
tbsgadiCommented:
Hi paganji,

It might be a formatting issue.
What do you enter in the text box?

Gary
0
 
Jeffrey CoachmanCommented:
paganji,

Also,
Make sure that this criteria is on the correct field.

JeffCoachman
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now