Recent content by cheater

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!