List Box 2 part question

[TheViruz30]

See attached database

List box connect to qryInsurance

Main Form Employees

1st Question is how to i add a wild star character so that if a user types a all insurances starting with that letter letter a will show up in the list box

User Type B, c d etc etc


2nd Question if you take a look at the main form employee you will see to text box One called Primary Insurance the other called secondary insurance
followed by a hyper link

The hyperlinks open the list box

What i want to do is when a user double clicks Insurance name from list box it will insert insurance name into text box

 

[wazz]

not much time now but,

1. in case you do not know: if you click a list box then type a letter you will go automatically to the first record starting with that letter. so consider not using a filter and the user can type a letter.

2. yourtxtbox = yourlistbox.column
something like that. do a quick search on list boxes. it's in here somewhere.

 

[TheViruz30]

Re: Reply

Okay Whay about the double click event

 

[TheViruz30]

Re: Wild Character

I figured the wild character out all i have to do is put a & "*" at the end of the qry after where it says search

now i just need to know how to do the double click event

 

[ansentry]

Have a look at the attached sample, I have made a new form frmEmployees_2.
I have used combo boxes to enter the insurance type.

If this is not what you want them no harm done.

 

[TheViruz30]

Re Combo

Is there anyway to double click from the list box to insert Insurance Name into fields

Want to avoid using combos

Only reason i want to use list box double click is because there is going to be a lot more information then what i'm detailing here

I tried putting all the information in the combo box but looks ugly

Liked your sample though will save it for later use

 

[ansentry]

You ask:

Is there anyway to double click from the list box to insert Insurance Name into fields

In your form frmInsuranceSearch (which contains the list box) you have 2 unbound boxes, which one do you want the data to appear in?

Let say you want it to appear in the one named "txtSearchString" then you would enter this code behing the double click event of the list box.

Me.txtSearchString = Me.List0.Column(1)

When posting a question be more precise about which fields, controls etc you are wanting help on.

Example:

insert Insurance Name into fields

Which fields do you mean?