Define Query Criteria Parameter Value from a List Box

[alexbel]

Hi,

I have a query with the following values in it:

Item ID
Item Text
Possible Answers
Correct Answer
Item Classification


Under Item Classification, I have the following criteria:

[Forms]![frmForm1]![Item Classification]

Here's what I want to do:

I have a list box on the form that lists all of the Item Classifications currently in the database. When the user clicks a certain Item Classification, I want a report (rptReport1) to open and display only the records that have the selected Item Classification.

So my question is....How can I have the list box automatically fill in the parameter value for the criteria with the user's selection?

Thank you

 

[Ziggurat]

Hi alexbel,

I think what you need to do is to create a query that you will use to populate your report. In the query select all the fields that you wish to output in the report.

In the selection condition for the field ItemClassification set the value to be the name of the listbox control that you have selected

eg if your form with the list box is frmForm and the list box control name is lsbListBox then the selection condition would be

[Forms]![frmForm]![lsbListBox]



#
###
#####
#######
Ziggurat