Combo Box Search

[Icy]

Hello, could anyone please help. I have unbound combo box as a serach box in
the main form. What I want to achive is when I type in a name for serach in
the combo box, I want the drop down list to appear, and a list of name will
appear according the serach string. for example. When I type "A" in the combo
box, a list of value ONLY start with letter "A" will appear "Auto, Animal,
Air, Apple" will be populated for choose. So the user can see what the choice
are and click on it then the value from the combo box will pass to a text
box. Is there anyway this could be done? Please help, any assistances will be
greatly appreciated.

 

[Jeanette Cunningham]

Icy,
yes this is normally the way a combo will work if its Auto Expand property
is set to Yes and its Limit To List property is set to Yes.
Are you have a particular problem with the combo on your form?

Jeanette Cunningham

 

[Icy]

Thanks so much so your reply. Both setting were at Yes, what I did is add a
DropDown comment, so user click on the combo box, the list will drop down for
viewing. However, what I really wants is to limit the selection on the drop
down list.
I have close to thousand entries on a combo box, when user serach the entry,
the combo box will highlight the record on the drop down list; Since there
are so many entires so when user move the scroll bar up and down, it will
take them from letter start with "A" to "M" or "Z".

When user tape "A"
a list of value ONLY start with letter "A" will appear "Auto, Animal,
Air, Apple" will be populated for choose on the drop down list. Nothing
start with letter "B" to "Z" will show. so when user scroll up and down, they
will be within "A" range.

Is there anyway you could help. Thanks again for your time.

 

[Jeanette Cunningham]

have a look at this http://www.allenbrowne.com/ser-32.html
combos with tens of thousands of records example

Jeanette Cunningham

 

[Icy]

thank you sooo much, this is what i am looking for. Could I ask you another
question, maybe you can point me at the right direction as well. I am create
access form on the share drive, so everyone has access to it. however, i want
to make sure no one can see or edit forms and table. I try the to hide the
table and form, is there any better way to accomplish this, such as excel
which you can set the password to protect the sheet and forms. Please advise.
Thanks again for you help.