I am trying to build a custom search form and having some challenges.
I created a form that pops up when a user hits the search button. It has a combo box with search by options (Ex. Name, City, State for the Organization table). And a Text box for the search string.
When the search button is clicked I would like a macro (or vb maybe, but my vb is very weak) to run a query through the organization table matching the string (from the text box) with the field (from the combo box).
The result should be a subform with all of the matches, and a button by each allowing the user to click on the correct record.