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

Clearing combo boxes and a text box 2
Link a text box based on drop down box with four options MS Word 365 0
Creating a Search using a combo box and then creating a report. 4
How do I set focus (and select text) on a text box on a modeless userform? 0
Need help removing extra TOC text from number lists used as TOC levels 0
Unable to display values in 2nd list box from 1st list box selection 2
use a list box to populate a text box 6
Keying in multiple entries for use as a parameter in query 6

Top