How to pass a criteria to Query from Form/via Button click

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sebtus
    New Member
    • Sep 2010
    • 2

    How to pass a criteria to Query from Form/via Button click

    I need help with this task...

    I have a form "myForm" which has multiple buttons on it, such as “John”, “Tom”.. etc, I have one Report "Parts Report" and Query "Parts Query" for that report, Query has a field "Owner".

    Case Example: when button "John" is click a report is generated and all entries with [Owner]="John" are listed

    When “Tom” button is clicked, criteria changes to “Tom” and all records with [Owner]=”Tom” are listed


    Any Idea how to get this done?
Working...