Need help to assign a combobox row source after 1 or 2 characters are typed in

[4hotn]

I used the combo box wizard to find a record on a form. But now we've past the combo box record limit. I want to assign the row source after 1-2 characters are typed in.


Need help on how to do this.

[ItsMe]

I think the listbox control can retrieve more records than the combo but I do not know for sure. I have never had a problem with it because I do not push their limits. Combos are slow performers.

I do not know what you mean by 1-2 characters typed in.

Maybe you should employ another combo. Have the first combo dictate the RowSource of the second, dependent, combo.

[June7]

That would require code in the combobox OnChange event to set the combobox RowSource property and to Requery the combobox. Review http://allenbrowne.com/ser-32.html

[Missinglinq]

Allen's hack for this problem is the one that I always suggest.

Linq ;0)>

[ItsMe]

Allen's hack for this problem is the one that I always suggest.

Linq ;0)>

After reading the solution, I think I now understand the question.

[4hotn]

I've tried Allen Browne's fix for this. I'm a self taught user and that fix is over my head. The first 2 steps confuse me because I don't know where the "general declarations" of the forms module is. And I can't find the "current" event. Isn't there an easier fix out there? I want to open a record on my form. I used the wizard to create a combo to do that and it has worked great for 10 years. But now we have exceeded the record limit for the combobox to work efficiently.

[June7]

I do not think so.

If it doesn't already exist, one way to initiate the form's code module is by opening the form in Design view, select the combobox and look at the Events tab on the Properties Sheet. Go to the OnChange event. Select [Event Procedure] then click the ellipsis (...) to open the VBA editor and you will be in the VBA procedure. Paste the event code as instructed by Allen.

The first two lines of every module should be:

Option Compare Database
Option Explicit

Those two lines are in the General Declarations section. Paste the first procedure from Allen's example just after those lines.

[4hotn]

Does anyone know of a sample database online that has Allen Browne's fix for this in use? It would help me enormously to see how it is implemented and then I should be able to get this to work.