code find button to search subform that returns main record

K

Kitten_7673

Hello All,

I hope you can help me. I have a book database that has the main form
(Books) and three subforms (DateInfo), (Series), (Author) they each have at
least three fields which includes an ID primary key (DateID), (SeriesID),
(AuthorID) and are connected by tables using one to many. I would like to be
able to search the subforms using the find command button to find each
instance of an author's name and going to the record it finds it in instead
of just the author relating to one book.
 
Top