Link to home
Start Free TrialLog in
Avatar of jrayos1976
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?
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Need an "s" on form:

Forms![Select Learner].[Full Name]
And depending on how you are using it, possible an exclamation point before Full Name:

Forms![Select Learner]![Full Name]
Avatar of jrayos1976
jrayos1976

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?
ASKER CERTIFIED SOLUTION
Avatar of Nick67
Nick67
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial