I just started using Access yesterday (I come from Rails/PHP but client wants Access) so I apologize for what I am assuming is a very basic question. I have worked out how to search and filter results as long as the search boxes are on the same form as the displaying data.
I'm dealing with a database with ~800k entries, so loading it and then filtering isn't ideal. I'd rather bring up the search criteria first, have those entered and then when "Submit" is clicked have it switch forms (This is the part I can't figure out).
This tutorial was helpful, but it is for reports and I haven't been able to adapt it to forms properly: http://allenbrowne.com/casu-08.html Any advice would be greatly appreciated.
Thank you.