All; I have an inherited database that one of the queries rely on a form and return fields based on whether a box is checked and a macro. I am trying to automate some of the activites in the database with cmdbuttons and vba. How do I revise this so it doesn’t rely on this form? I can take the form!.... in the criteria but I get different results. Help please.