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

Access 2010 Input Box to Search Form

P: 11
How do I create a search by three different field search options to bring up a record to revise that record based on what was searched for.

I.E. I have 20 fields (I want to search by Field 1, Field 2 or Field 3) bring up the record associated with the searched request (If I don't have information for Field 1, search by Field 2, if I don't have the information for either field 1 or field 2, search for field 3). Once the record is displayed (based on the fields of the form) allow record to be updated by user filling in any blank fields.

The information that the user typed in populates the table record.
Mar 12 '15 #1
Share this Question
Share on Google+
1 Reply


jforbes
Expert 100+
P: 1,107
This is a pretty broad subject. I would see if this is what you are looking for first: http://bytes.com/topic/access/insigh...filtering-form
If you have a more refined question after reading this or if it is completely off the mark, let us know.
Mar 12 '15 #2

Post your reply

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