Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010
    Posts
    3

    Unanswered: Dynamic Query with Forms

    Hello,



    I have a form split such this:

    http://img21.com/images/qbzwutn4o6mw1rjtv65.jpg

    and i want , when i press "Submit Query" the result of query show in the below of form.

    thanks alot

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Code:
    Private Sub Command_SubMitQuery_Click()
    
        Me.RecordSource = "<Name of the Query>"
        
    End Sub
    You can also assemble a Filter (= WHERE column1 = 'Something', etc..., but without the word "where"), then apply the filter:
    Code:
    Private Sub Command_SubMitQuery_Click()
    
        Me.Filter = "<Filter string>"
        Me.FilterOn = True
        
    End Sub
    Have a nice day!

Posting Permissions

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