Add new record command button not working in tabbed form



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

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 Sub

MsgBox Err.Description
Resume Exit_NewEntry_Click

End Sub

Jeanette Cunningham

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question