Continuous Form Combobox Search as you Type (1 Viewer)

[aron.ridgway]

Hi There

What i want is to have a combo box on a continuous form that as you type it filters the Query it is based on using a Like *. and drops downs so the user can see the updated list after each key press?

Does anyone know if this is possible?

 

[CJ_London]

From what you describe, probably not but it does depend on where your combo box is.

If it is in the detail section then its maximum height is the height of the detail section so

and drops downs so the user can see the updated list

you would probably only see one or two rows.

Having said that, the basic principle is feasible, there are 100's of threads on this forum covering this topic.

Here is an example

http://www.access-programmers.co.uk/forums/showthread.php?t=266743&highlight=filter+as+you+type

EDIT: if you look at the similar threads section at the bottom of this page, you will find a number more

 

[Thales750]

EDIT: if you look at the similar threads section at the bottom of this page, you will find a number more

How does the system know about similar threads?

 

[CJ_London]

How does the system know about similar threads?

Don't know for sure, but an educated guess would be from the words in the thread title.

All the suggested threads for this thread have the words 'continuous form' and 'combobox' in the title

 

[vbaInet]

The drop down of a combo box does spill over records in a continuous form but the main issue here is that a combo box's Row Source is the same for all records and if you filter it on the current row it will affect all the other rows.

There are tricks around this.