Hi,
I created a database with a table that has customer info - including sales history. I want to create a form so that i can search based on various criteria (first name, last name, purchase date, etc.). I was able to create a form and tried adding a command button to search records but it only looks at the field where my cursor is and only returns the first record that it finds. How can i add a search button that will search an entire database bases on all of the criteria that im entering? Also - i dont know code so the easier the better! Thanks so much!
Rachael
I created a database with a table that has customer info - including sales history. I want to create a form so that i can search based on various criteria (first name, last name, purchase date, etc.). I was able to create a form and tried adding a command button to search records but it only looks at the field where my cursor is and only returns the first record that it finds. How can i add a search button that will search an entire database bases on all of the criteria that im entering? Also - i dont know code so the easier the better! Thanks so much!
Rachael
Comment