Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2003
    Posts
    1
    Thanks
    0
    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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()
    With Me.sbfSomething.Form
    .Filter = "LastName Like '" & Me.[Which].Text & "*'"
    .FilterOn = True
    End With
    End Sub</pre>

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •