Access 2013 form with lookup function for updating records
Posted on 2014-09-22
I have been creating a project in Access 2013 and have no prior experience with Access but with help from people like you, things have been working well. I have a single table, a report and a data entry form which people use to enter records into a simple single table. Now they need a form to update records. I have found that creating a form using the wizard works when I change the form properties to NO for Allow Additions and NO for Allow Deletions. The problem with updating the data using this simple form is that you have to scroll through many records to find the one you need to change. My question is how can I setup a function to allow the user to select the record he needs to update? The field to use would be JobTicket.Jobnum. Can you please help me design this form so the user can pick the record he needs to update using the Jobnum field? Thank you very much!