jrayos1976
asked on
MS Access 2010 - pass a variable from a Listbox to report
In a database that I created, there is a form called "Select Learner" with a list box called "Full Name". I want to use the selection in the listbox as filter to run a report. I have tried using the following criteria in the query for the report to filter but when the query runs I get an "Enter Parameters Value" popup.
[Form]![Select Learner].[Full Name]
It appears that listbox value is being passed as null
How can I accomplish this?
[Form]![Select Learner].[Full Name]
It appears that listbox value is being passed as null
How can I accomplish this?
And depending on how you are using it, possible an exclamation point before Full Name:
Forms![Select Learner]![Full Name]
Forms![Select Learner]![Full Name]
ASKER
It is till not working. I tried an exclamation point as well. Before runnig the query do I need to perform a save function once I select a value from the listbox. The reason I ask, is everytime i open the form nothing is selected.
If your listbox is bound to a field in the underlying table or query, possibly.
Can you post a sample of your database?
Can you post a sample of your database?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forms![Select Learner].[Full Name]