Insert record from list box to combo/text box

J

jeremy0028

I know you could do this is vb but i dont know if you could do it in
access. cant find anything on the net.

I have the following in a table called tblinsurance

InsuranceID(Auto)
InsuranceName
InsuranceAddress
InsuranceCity
InsuranceState
InsuranceZip

The list box is called let say list37 which looks up the above
information.

I have a combo box called Insurance which is on a form called
frmpeopleinsurance which has the following code(SELECT
[tblInsurance].[InsuranceID], [tblInsurance].[InsuranceName],
[tblInsurance].[InsuranceAddress], [tblInsurance].[InsuranceAddress2],
[tblInsurance].[InsuranceCity], [tblInsurance].[InsuranceState],
[tblInsurance].[InsuranceZip] FROM [tblInsurance];)

which looks up the above info as well. near the combo box i have a
hyper link which opens the list box so users can search more details
from the list box which has serveral filters.


What i want to do is when user double clicks the insurance from the
list box it will inert that insurance info into the combo box or text.

Is there any way to do this
 
Top