MS Access GUI search function

Clasni

Reputable
Aug 16, 2015
38
0
4,540
Hello, I am trying to build a GUI using Access 2007 built in tools. The problem is I have not been able to set a search query the way i want to.

Basically all i want to do is have the user type into a field something and have MS Access populate other fields with information.

IE: The user types in "Brand" in the search box and below there will be field like "Address", "Category" and "TEL".

I have all the data in a Table already. Any help will be appreciated.
 

PassMark

Distinguished
I don't want to tell you how to built your application, but have you considered doing it as a web based solution?

I don't know anyone who is using Access anymore as a user interface, everything has moved to the web / intranet / cloud.
 

Clasni

Reputable
Aug 16, 2015
38
0
4,540


I know, it would be so much easier if i could just make something in .net but the problem is im restricted to MS office tools. The company that i work for only allows MS Office solutions, Thanks Anyway.