PC Review


Reply
Thread Tools Rate Thread

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

 
 
jonesfranckandi@yahoo.fr
Guest
Posts: n/a
 
      3rd Jan 2007
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!!!!.

 
Reply With Quote
 
 
 
 
HLCruz via AccessMonster.com
Guest
Posts: n/a
 
      3rd Jan 2007
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

(E-Mail Removed) wrote:
>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!!!!.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200701/1

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
display data form chosen record of a list genjuro123 Microsoft Excel Discussion 0 9th Nov 2006 10:24 AM
Form with search via text box with display of result in list box Christian Microsoft Access Forms 0 23rd Dec 2004 01:54 PM
Display new record field at top of list in a continuous form Lizzy98 Microsoft Access Forms 1 16th Apr 2004 04:24 AM
Get the last record from a filtered table and display in a text box on form. Les Microsoft Access Form Coding 10 3rd Dec 2003 06:38 PM
Return Record; Display Record from List Box Tiffany Microsoft Access Forms 3 11th Nov 2003 09:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:12 PM.