By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,377 Members | 1,722 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,377 IT Pros & Developers. It's quick & easy.

How can i easily create a form that will search based on criteria in multiple fields?

P: 1
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
Jul 1 '10 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,768
Try Example Filtering on a Form out Rachael. I think it's all you need.

Welcome to Bytes!
Jul 1 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.