In the picture below you see a main form and a tabcontrol with two subforms on it, what I would like to do is make is so the users can search by First Name or Last Name which resides in the (Subject Subform). right now I'm using the Find And Replace command button microsoft provides but that doesnt seach by subforms as well as the mainform. I want to provide a search with different options basically and have the results appear in the form just as they would with the Find and Replace Search. Does that make sense?? the primary table is the Reports table(Incident Reports) which has the Subject and Victim as the child tables. any ideas on how to do this??
I have been trying to do this for months now.
I have been trying to do this for months now.
