[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1948
  • 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 CoachmanMIS LiasonCommented:
paganji,

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

JeffCoachman
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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