Help with Search Forms/SubForms

[KCC47]

I am needing some assistance setting up a few different kind of forms. These forms will primarily be used to search for records outside of the master form because the master form doesn't have stored on it identifiable information to the end users.

An applicant search form. Search for applicant by last name, first name, middle initial, and suffix. After finding applicant record, I need a subform showing any linked records to the main form. My issues is that this subform never shows the information I need; in this case it needs to be information on the vehicle (VIN, Make, YR). From there I think a hyperlink should be possible to select the VIN and open the master form for that record.

A office form. Search for an office, and it would show all records that originated at that office in a subform. Same as above in regards to a hyperlink on the VIN.

A dealer form. Search for a dealer by name or dealer #, and it would show all records for that dealer in a subform. Same as above for hyperlink to VIN.

A deputy clerk form. Search for a deputy clerk by name or initials, and it would show all records that match that deputy clerk. Hyperlink to VIN.

If I could get help on just one of these forms for searching, I could probably learn how to do it for the others.

[June7]

Here is one technique for filtering records http://datapigtechnologies.com/flash...tomfilter.html