I want to create a search function that will allow me to search for a record on a particular query based on the data on 2 fields on a form.
My database has a query named Loan Query. I am created a form of that query that on load will create a new record. 2 fields on the form are Book ID and Member ID(I have another form through which the data is entered into the query). The query is designed such that the when the Book ID is entered, its title is automatically filled in by the database by retrieving information from other tables(the same applies for Member ID).
Now I want the form to search for record in the Loan Query whose Book ID and Member ID fields value are equal to the value of the Book ID and Member ID entered in the fields of the form.
My database has a query named Loan Query. I am created a form of that query that on load will create a new record. 2 fields on the form are Book ID and Member ID(I have another form through which the data is entered into the query). The query is designed such that the when the Book ID is entered, its title is automatically filled in by the database by retrieving information from other tables(the same applies for Member ID).
Now I want the form to search for record in the Loan Query whose Book ID and Member ID fields value are equal to the value of the Book ID and Member ID entered in the fields of the form.
