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
 
Back
Top