Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
AUTOFILTER
- Thread starter wangling
- Start date
If I read you right, you want to have a text box on the main form which, as you type in characters, will update a subform depending on the characters typed so far?
If so, I think you would have to write code to check the contents of the box after each OnChange event for the text box, i.e. this will be called after each character is typed. Then, in code, requery the subform based on the contents at that stage.
I don't think there is any control that will do this automatically. A combo box will "auto-complete" as you type if an item already exists in the list but I don't think that is what you are looking for. Have fun!
)
Alex Middleton
If so, I think you would have to write code to check the contents of the box after each OnChange event for the text box, i.e. this will be called after each character is typed. Then, in code, requery the subform based on the contents at that stage.
I don't think there is any control that will do this automatically. A combo box will "auto-complete" as you type if an item already exists in the list but I don't think that is what you are looking for. Have fun!
)Alex Middleton
- Status
