Access 2010 Use query to update one field on data entry form
Posted on 2014-02-08
I am new to Access and have a question that is probably quite simple for an expert.
I am using Access 2010. I have a Data Entry Form (NewItem) which updates fields in tbl_Assets. I have a query (qry_NewSerial) which finds the last serial number and generates the next serial number.
This is what I am trying to accomplish:
A user opens the form - NewItem. A new record is created. The query automatically runs. The value generated in NewSerial is automatically entered in either the form which then updates the ID field in the table, or in the ID field of the table which then displays on the form.
I have all the other fields on the form working the way I would like, and it does create a new record. I'm just missing the way to link my query to the form, so the user does not have to guess a serial number.
Any assistance would be appreciated.