I have an app that I am converting it has 20 or so forms and I know the users constantly use the filter and search functions built into Access. I want to duplicate these but am unsure how. If I have a form and it is loaded from a dataset with 3000 records. THe user wishes to search for the a certain Last_Name or Employee_ID. So I want it to add a context menu that has a filter and a search function. Now, do I want to add a form that is brought up when they choose search to ask for the text to be inputted so I know what they are looking for? and how will it know what field I am searching on by the click? and lastly, do I just write an sql statement to complete the search and then reload the dataset? I am just unsure if this is how most people do it or am I missing the boat?
