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

  • Thread starter Thread starter KHogwood-Thompson
  • Start date Start date
K

KHogwood-Thompson

Hi All,

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

SELECT [JOB REF].[JOB REF] FROM [JOB REF]

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
 
On my website (www.rogersaccesslibrary.com), are two small Access database
samples called "CreateQueries2.mdb" and "MultiSelectListboxes.mdb" which
illustrate how to do this. You can find them here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=368 and here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=315

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 

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

Similar Threads

Keying in multiple entries for use as a parameter in query 6
use a list box to populate a text box 6
List Box Error 2
Linking Combo Box to Text Box 7
Populate a text box from a combo box selection 2
Text Box populate 3
auto populate text box based on combo box value 1
Populating text box using selections from multiselection list box 2

Back
Top