List Box Double Click Event Please Help

[TheViruz30]

Please see attached database

Main form is frmPatients

If you click on the main form called frmpatient you will see 2
text boxs one called Primary Insurance the other Called Secondary Insurance

Above those text boxes are to hyper links which open the list box


What I'm trying to do is if a user double clicks the name of the Insurance
From the List Box it will insert that Name of the Insurance Into either
The Primary Insurance or Secondary Insurance Text Fields

I do not Want to Use combo Boxes because I have about 1,000 Insurances in my database.


Please Help

 

[llkhoutx]

Attached is a zipped simple solution.

 

[TheViruz30]

Re: Reply

I already have the code for the list box but didnt include it here

I want the User to double click the Name of the Insurance in the List Box
And Insert the Name into the Primary Insurance Text Field on the Main
form which is frmPatients

 

[ansentry]

Have a look at the changes I have made, if you don't like them just disregard this post.