I have a database where I’m storing customer data which has to be modified rather frequently. In order to find the correct record to modify I pull up the form showing customer data, then try to find the correct customer (about 75 unique records). Using the search at the bottom of the form is one way, but takes time as some customer names are similar. Using filters is great and lets me jump directly to where I want, but the records are locked out and I cannot modify them when a filter is active.
Does anyone know how to bypass this issue?
Edit: I’m using Access 2016.