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

  • Thread starter KHogwood-Thompson
  • 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
 
R

Roger Carlson

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

use a list box to populate a text box 6
List Box Error 2
Keying in multiple entries for use as a parameter in query 6
Populate a text box from a combo box selection 2
Clear Unbound Text box used as input parameter to query 13
Linking Combo Box to Text Box 7
Multi-Select LIst Box Not Appearing in Text Box 2
auto populate text box based on combo box value 1

Top