I have two tables, one for Member Demographics, one for Member details. A Member can have up to three terms. Each term is for two years and has it's own contract. The Relationship has been built to link on member #. Member #is the PK in the Demographic Table. Contract # is the PK in the Detail table. I created a subform linking the details to a Parent Demographic table. I then tried to add a "Add New Contract" to the subform (BOARD_DETAILS1) that would open a blank entry in the subform. The Code is below
Private Sub btnAddNewContract_Click()
Me![BOARD_DETAILS1].SetFocus
Me.AllowEdits = True
DoCmd.GoToRecord , , acNewRec
End Sub
I keep getting the following error when clicking the button created.
I only want the user to be able to add to the contracts table (Board Details) if they select the add new contract button.
Please help.