Search results

Hi there everyone... I'm creating a database for an equipment sign out system in a college. At the moment, I have a form to type in the students details, equipment borrowed and date due back. When the student brings equipment back, I can bring up their details by searching for their name...

Is there a way of doing a parameter query that will search more than one field at a time? At the moment I can search one at a time using this method, but for what I'm trying to do this is too time consuming. There MUST be a way!!!