Selection from List Box displays information in a text box on the same form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up the list box of vendors names so that when I click on the vendor name it will display the phone number for that vendor in the phone number textbox on the same form. The text box phone number is located in the second column on the vendor table. Need to know what lines of coding I need to use to get this to work

Thank you.
 
Just one more thing. The first version of code is really set up for a combo box (that's why the NoMatch stuff in there). The second shorter version should work just fine for your list box. I only put the other up there just in case you wanted to use a combo box instead of a listbox

Rick...
 
You must log in or register to reply here.

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

Combo Box selection / AUTO POPULATE subsequent text boxes 8
DLOOKUP 2
Subform causing duplicate records? 7
Build search function in to a form 5
List box 4
HOW do I make selections and carry only those selections thru proc 1
Only enter a certain number of values in a text box? Access 2000 5
Refreshing main form from the subform 1

Back
Top