Add new record command button not working in tabbed form

  • Thread starter Thread starter ERA55
  • Start date Start date
E

ERA55

I have a tabbed form within a main form (Access 2003). How can I add new
records in the tabbed form without incrementing the main form? The table used
in the main form has a one to many relationship with the table in the main
form.

I entered a command button and selected the Add New Record operation but it
does not add a new record in the tabbed form. It does not give an error.

Private Sub NewEntry_Click()
On Error GoTo Err_NewEntry_Click


DoCmd.GoToRecord , , acNewRec

Exit_NewEntry_Click:
Exit Sub

Err_NewEntry_Click:
MsgBox Err.Description
Resume Exit_NewEntry_Click

End Sub
 
Hi ERA55,
Look at the Link Master Field and Link Child Field.
To do this, on the main form in design view look at the Data tab of the
properties dialog.
The Link Master Field would be set to the field that is the primary key in
the main table and the Link Child Field would be set to the field that is
the foreign key in the subform.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top