Results 1 to 2 of 2
Thread: on keypress Seek (Access 2002)
2003-08-20, 20:49 #1
- Join Date
- Aug 2003
- Thanked 0 Times in 0 Posts
on keypress Seek (Access 2002)
I Want to make on key press in Field Which Impact directly seek on Subform like when I press A in Field it impact on subform get all name which start by A
2003-08-20, 21:16 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: on keypress Seek (Access 2002)
What a breathless sentence!
If I understand you correctly, you have a text box named Which (or Which Impact, that is not entirely clear to me). You write field, but I think it should be an unbound text box. That means that the Control Source property is empty.
You can write code in the On Change event of the text box that filters the subform. Since you haven't told us what the name of the subform is, or of the field on which you want to filter, I will give an example with fictitious names. You will have to replace these with the name of your subform, etc.<pre>Private Sub Which_Change()
.Filter = "LastName Like '" & Me.[Which].Text & "*'"
.FilterOn = True
Note the way single and double quotes are used.
If this does not help, please try to explain as clearly as you can what you want, with details.