Search Function

M

Matthew DeAngelis

I am having trouble adding a search feature to my database. Basically,
I have been asked to construct a search mechanism that would allow me
to search the entire database (every field of every record) for a
value. I tried simply creating a form that would display every field
for searching with the Access search function (binoculars). However, I
cannot figure out how to set it up to search subforms as well as the
main form, if that is even possible.

I think I might have to build my own search function in code. I have
done some work with recordsets, but really only to test for nulls in
certain fields. While I have looped through all of the records on one
field, I do not know how to move from one field to the next. Also,
since I will be searching many tables, I am not sure how I can capture
and display hits within a form (if there is a hit on a table that is
only displayed in subforms, for instance). Does anyone out there have
an example of a search like the one I have described that I might use
as a template?


Thanks,
Matt
 
Top