Filter Macro

cheater

New member
Local time
Today, 15:35
Joined
Apr 23, 2007
Messages
1
Can anyone tell me how exactly I can create a macro which takes a user input and uses it as a filter in a query to display only selected info?

Please, I need this ASAP...emergency!
 
check here, I just posted a reply, this iis the easiest way, filtering by the forms criteria you can open the query or a report bound to the query based on selected records.

http://www.access-programmers.co.uk/forums/showthread.php?t=127146

I also sometimes make another table (criteria table) which allows me to enter multiple criteria, like if I wanted to see records for certain people or a select list of Products. You then make a join query and set the join to retun only those records from the criteria table.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom