Command Button that will set new parameters for a query in a subform

[NickWren]

I have a form that uses filters and query criteria to find and see the status' of our samples in our lab, I only got the filter buttons to work, but I want to use either a where command or use the queries criteria and a hidden textbox to only show certain records within the last week, month, ect...

My main form that has several buttons;

• one removes the filter showing all tests
• one shows only one type of test
• and the other show the other type of test

Now I want to separate it by date buttons; this week (>Date()-7), last month(>Date()-31), last quarter(>Date()-92), last year(>Date()-365)


(all I need is one of these buttons vba command to work and I can get the rest from that one)

Eventually I'd want to be able to have a search criteria pop up when you hit find;
this will be able to find a certain Sample ID, Patient Name (or Patient ID), Physician Name

-Pretty much for that one I just need to have a second form popup that will give requery the subform to give me the record we searched for.

[Perceptus]

You could have a hidden unbound field in the subform, and update the value of that field then requery. (in theory)