Improve company productivity with a Business Account.Sign Up

x
?
Solved

Listbox won't display records related to key field

Posted on 2014-01-14
1
Medium Priority
?
554 Views
Last Modified: 2014-01-14
I have a listbox I'm adding to a form but it will not display only the records related to the key field on the form named "txtCustID".

In the query for the listbox I do have the criteria for CustID to be [Forms]![frmCallLog]![txtCustID].

What am I doing wrong?

If I leave the criteria out of the query I get all records not just the ones related to that customer.

If I leave the criteria in the query I get an enter parameter value window popup.
0
Comment
Question by:SteveL13
1 Comment
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 total points
ID: 39779780
The parameter popup means that the textbox in your criteria is unrecognized.

double check the textbox (or field name) and the form name.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question