searching, filtering in a subform using a textbox in a form

[fedum]

I would like to make a form with a subform. On the form I place a textbox. In the subform the fields of a table tblCategorie (Id, Categorie)
What I would like to do is when typing into the textbox (normaly a new categorie) then the subform has to follow the text into the textbox. The meaning is that I can see if the categorie already exits. So if I type r in the textbox all categories starting with r wil be displayed, re all categories starting with re will be diplayd etc. Is this possible?

 

[PHV]

Why not using a ComboBox instead ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fedum]

How can I use the combobox if it is a new article?

 

[PHV]

Have a look at the NotInList event and the LimitToList property.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fedum]

Ok, combobox works, NotInList is usefull. But I still would like that the subform field catagorie follows the typing in the combox so I can see all the categories that have the same "like" name.
I think I have to work with filtering and a "like *". Can you advise?
Thanks

 

[PHV]

Use the Change event procedure and the Text property of the ComboBox to dynamically reset the Filter property of the subform.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886