List box to populate a text box and be used as a parameter in a qu

  • Thread starter KHogwood-Thompson
  • Start date


Hi All,

I have a multi-select list box called "lbjobref" on a form called
"frmcostsummary" that is populated using the following row source:


I want the user selection to appear in a text box on the form called
"txtjobref" and then the results of thsi textbox to be used as a parameter in
the query "qrycostreport" for the field "jobref".

Can anyone help with coding etc

Roger Carlson

On my website (, are two small Access database
samples called "CreateQueries2.mdb" and "MultiSelectListboxes.mdb" which
illustrate how to do this. You can find them here: and here:

--Roger Carlson
MS Access MVP
Access Database Samples:
Want answers to your Access questions in your Email?
Free subscription:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question