How do I write SQL code to run a query on enter?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Yana Smith

    #1

    How do I write SQL code to run a query on enter?

    I have a form within a form: linked by child/master fields. The query in the subForm needs to run when the text field has been populated and the user clicks "Enter". That same text field is used in the subform query. Is there anyway to do that w/out the command button? At this point, the user has to go to another record or exit out and go back, before the text field in the main form is populated. Any help is greatly appreciated!
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32669

    #2
    You can call a Requery of the subform. You don't tell us the names of any of your objects so the best I can do is link you to Referring to Items on a Sub-Form.

    Comment

    Working...