Hi, I am a newbie to Access 2007. I'm doing an Inventory Database for my company and unfortunately I'm running into a couple of problems. But the first one is:
I have 2 tables: tblAsset with AssetID as PK and tblManufacturer with ManufacturerID as PK.
I have a main form with several navigation buttons such as Add Record, Update Record and View Report.
When user clicks on Add Record button, a new form is generated with fields from tables. At the bottom there is a Save button and I want it to perform the adding new record to table. However when I click on Save, there is an error says, "Cannot find specified record". I've seen many threads about this problem but still couldn't figure out the right solution.
Here's my code for the save button:
Private Sub btnSave_Click()
On Error GoTo Err_btnSave_Click
DoCmd.GoToRecord , , acNewRec
Exit_btnSave_Click:
Exit Sub
Err_btnSave_Click:
MsgBox Err.Description
Resume Exit_btnSave_Click
End Sub
Any helps will be appreciated!