Display a record in text box using a list in a form!!!!

  • Thread starter jonesfranckandi
  • Start date
J

jonesfranckandi

hi everyone
thank you for your help. I have created recently in access a drop down
list in a form where there is a list of company to select from. I have
also created a button next to a text box. The button opens this form.
Now what I want is when the user click( or dble click) on a record it
displays on text box next to it. Does anyone knows how to do this. I
need help Please!!!
Thank you in advance!!!!.
 
H

HLCruz via AccessMonster.com

I used a similar approach, but backwards, I was synchronizing the name in my
combo box with the name in my text box ... I believe this should work, just
use your own list & text box names and your own related field name ...

Private Sub Form_Current()
'Synchronize name in combo box with displayed record.
cboFindRecord = Key
txtKeySearch = Key

End Sub
 
Top