Filter as you type text box on Split form

[abakhaus]

I have a Split Form with a text box on the Form Header to filter a Query database in the Form Footer.

My Text box name is Catalogdescriptiontxt(Filter). The column in the query I am trying to filter is CatalogDescription along with the other columns that are in the same row in the database as the CatalogDescription.

I would like the Catalogdescriptiontxt box to filter the query in the Form footer as you type. But I am having all sorts of issues figuring this out.



Please Help!

[ranman256]

youd be doing many filters (1 per character)
instead of 1 single filter.

this takes up resources. Can the user not wait until the typing is finished?

[abakhaus]

I have been doing alot of research on this online and it looks like it shouldn't be to hard I just can't get it to work correctly.

[abakhaus]

The reason I cant wait until they finish typing is because the people that are using this are selecting components in our catalog. They need to see a list of parts that they can choose from not just one.

[abakhaus]

Can someone please help!

[John_G]

...filter the query in the Form footer...

I'm going to assume you mean the bottom of the split form.

I don't use split forms, so I'm not sure of the syntax, but basically you are going to reset the filter for the bottom of the split form as you go.

You would put some code in the On Change event procedure of the Catalogdescriptiontxt(Filter) textbox. The code would run after every character you type in the textbox, and would reset the Filter property of the bottom part and then requery the bottom part.


The syntax of the filter would depend on how you wanted to do the filtering but if for example you wanted to filter using "starts with" you might have something like this:

(bottompart).filter = "CatalogDescription like '" & Catalogdescriptiontxt(Filter) & "*'"
(bottompart).requery

As I said, I am not familiar with split forms, so I don't know the exact syntax..