Searchbox that that searchs multiple columns?

This is my first post here I hope I’m well understood.

I’m currently building a database with two tables(hopefully will expand more) one table for contacts info and one for evaluation. I have a data entry form and an evaluation form. I need to have a search box with following features for my evaluation form: 1. If the user entered a phone number, address or name etc. And hit enter. A second form should pop up showing relevant results. 2. That second form should also have a search box that basically filters the data based on what the user types (like a second level search) and dynamically shows the results. 3. The user them double clicks the desired contact And loads their ID to the Evaluation from for more data to be entered.

Are these ideas doable in Access If they how should I go about it ? Any help is very appreciated.

submitted by /u/seekingtruth2
[link] [comments]

Posted on