list box on a form, selection to be used a criteria in query?

  • Thread starter Thread starter Harold
  • Start date Start date
H

Harold

I have created a list box on a form, I used the week list on a table to
populate the list.

I want to be able to select the appropriate week, and click the button I
have added, the button
runs a set of queries, and in one of the quires I want to us the week
selected as a criteria..

How do I get the selection from my list box (lstBoxWeekly) to be the
criteria in my query??
 
Harold,

In the query design, your criterion would be something like:

Forms!YourFormName!lstBoxWeekly

where YourFormName should be changed to the actual name of the form the
listbox is on.

HTH,
Nikos
 
Back
Top