Easy way to do Find as you type

[chigley3]

Hello there,

I have a combo box that finds claim numbers for example 499a, 456a Named MANUFACTURER Claim No in a combo169 which runs off a normal query to give the result.

How can I use Find as You Type within this?

I have seen similar postings but have tried to code and cant get it working.

please Help

 

[dhookom]

You might want to explain what you mean by "find as you type". Combo boxes with the Auto Expand property set to Yes, should find as you type. This requires no code or anything else.

Duane
Hook'D on Access
MS Access MVP

 

[chigley3]

Find as you type meaning that all other informations is not available to select when you have entered certain values.

for example, if i enter 428

500a
530a
427a
428a
428b
429a

all i want to see is 428a and 428b

 

[dhookom]

Did you research faq702-6304 as suggested in the other thread?

Duane
Hook'D on Access
MS Access MVP

 

[chigley3]

Yeah I did, where do I start?

I have a combo box called Combo169...

I dont really understand the instructions, could you give a break down.

 

[dhookom]

Sorry but I didn't write the code and don't have the time to test and document it for you. You can follow in the other thread or comment from within the FAQ.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

You start by reading the instructions, attempting the code, and then reporting back specific problems. What do you not understand?

1)Place the code into a class Module named "FindAsYouTypeCombo".

2)Call your combo "cmboFilter"

3)On your form it should look like this

Option Compare Database
Option Explicit

Public faytCmbo As New FindAsYouTypeCombo
Private Sub Form_Load()
faytCmbo.InitalizeFilterCombo Me.cmboFilter, "YourFieldName", False
End Sub

4) "YourFieldName" is the filter that gets filtered like "LastName"
5)True if you want it to filter from the beginning of the code
false if it filters anywhere in the code.

Unlikely if you can not understand the above that you could possibly code your own.

 

[MajP]

Did you look at the demo? Also do not post multiple times for the same subject.