I have an Access database that keeps track of customer complaints. I need the search section updated to allow searching for specific things related to the customer (such as last name, location, etc).
I have a table for adding new customers. I need a few fields added to this area (a field for the amount of the gift card given to the customer as compensation, a field for the actual complaint from the customer (food was cold, wrong item, etc) and I need the apology letter section to use a drop down menu to select the apology text to use instead of a free text field)
On the main/start window I want the middle option "complaints" to be removed and leave only the "Customer Entry" and "Search" buttons.
I want the search window changed up completely. It will have a blank for free text, a drop down menu for select which field to search in, and a search button. When the search button is pressed it will bring up a new window with a list of the results.
When selecting customer entry and the window comes up I want it blank with no customer listed by default.
You will need to edit the copy of the access file I have because I have added in the 2300+ customer names from past complaints already.
I'll add an image here to show what I want under the customer entry and search sections.