I am a Access and SQL database developer, I would like to design and build my own searches on a form by either entering some search criteria and then only show the relevant info but using either 2010 macros or VBA. I can then use buttons to search that information using only specific fields on the form etc. I would like to create my own advanced searches on a form. for instance I have a database with a list of projects, when you double click on any of those records the project detail form will appear. the list now contains more than a thousand records. I want to search for say all projects in New York by pressing a button and then I want all projects more than $ 100 000 within the current search , I want to print that List and then remove the filter to show all records again with the most recent projects at the top. this is just an example. I would like to know how to use macros and VBA to create my own fields and search buttons. Is it possible to build your own search criteria by right clicking on a record or field like the one that is availalbe in Access 2007 and 2010 but showing only search options that I have specified.