Text box value base on ListBox (1 Viewer)

P

Pro

Registered User.

Local time

Today, 15:55

Joined

Apr 28, 2015

Messages

19

• Apr 28, 2015

• #1

Hello All

I have 2 form ( Form A & Form B )
Form A contend Contain ListBox
Form B contend Contain bound Text box

I need to know how when double click ListBox at Form A passing value of listbox.Column(0) to bound Text box at Form B

Please at expiration builder if can

Thanks ...

 

pr2-eugin

Super Moderator

Local time

Today, 13:55

Joined

Nov 30, 2011

Messages

8,494

• Apr 28, 2015

• #2

Cross Posted at Stack Overflow -> https://stackoverflow.com/questions/29917922/text-box-value-base-on-listbox

Please have a quick read : http://www.excelguru.ca/content.php?184

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 13:55

Joined

Feb 19, 2013

Messages

16,607

• Apr 28, 2015

• #3

in the listbox doubleclick event put

forms![Form B].form.boundtextbox=me.listbox.Column(0)

Note: Form B must be open otherwise you will get an error

 

P

Pro

Registered User.

Local time

Today, 15:55

Joined

Apr 28, 2015

Messages

19

• Apr 28, 2015

• #4

Dear pr2-eugin Sorry for that ! how I can fix it ?

 

P

Pro

Registered User.

Local time

Today, 15:55

Joined

Apr 28, 2015

Messages

19

• Apr 28, 2015

• #5

Dear CJ_London
Thank You Very Mach it Solved