I don't have much experience with MS Access, but I am trying to update an old database a previous employee created. I know the basics of how to create a table, form, and query however I do not know what expressions/queries/macros needed to make them all work together. The goal is to create a user interface where the information is accessible to people that have no Access experience.
I have a table with my columns labeled Operator ID #, Tract #, Farm #, Landowner Name, Operator Name1, Operator Name2, Operator Name3, Farm Address, Farm City, and Date Revised in Database. My goal is to create a search form (see Figure 1) to pull up any record from the table that matches the information entered into the form and show all the results. For example, if the user only knew the Tract # they could enter it into the search form, press the search button/Enter, and the entire record shows in a read-only form. Another goal I would like to achieve, is if the user enters information into one of the fields search boxes that will bring up multiple records, such as Farm City, I would like a read-only table to show up in a form with all the results for Farm City. The read-only table should show a limited amount of information (Farm City, Operator ID #, Farm #, Tract #, and Landowner Name), but when one of the records in the table is clicked, I want all of the selected record's information to show above the table of search results (see Figure 2). I would also like to have a form where an authorized user can edit the table (see Figure 3).
