O
Ozzwald
Hi,
I have the main form which holds the customers data, and
in the sub-
form, I have the books that they are looking for.
What I need to do is be able to search all 4 fields
(Title, Author,
Publisher, and ISBN) when I input anything in to a search
field, and
then to display the details of that Customer in the main
form with
all of their books in the subform.
I have looked at Access help, and not found anything that
I can work
out how to do.
Ideally I would like the 'Search Box' on the Main Form,
but would be
happy if it was another form.
Thank you in advance.
Ozz
I have the main form which holds the customers data, and
in the sub-
form, I have the books that they are looking for.
What I need to do is be able to search all 4 fields
(Title, Author,
Publisher, and ISBN) when I input anything in to a search
field, and
then to display the details of that Customer in the main
form with
all of their books in the subform.
I have looked at Access help, and not found anything that
I can work
out how to do.
Ideally I would like the 'Search Box' on the Main Form,
but would be
happy if it was another form.
Thank you in advance.
Ozz