Adding new record in a tabbed form

[menkenk]

Hello,

I created a form with multiple tabs. They are labeled as Info, Policy, Riders. The Info Tab is linked to the Client Information Table, the Policy tab is linked to the Client Policy Information Table, and the Riders Tab is linked to the Riders Information Table. I created an Add new record command button on this form, but when I click on it, it clears all the fields on all tabs. My problem is that a client can have multiple policies and I would like to be able to add a new record for the Policy and Riders tab. The add new record command button I had originally made is only useful for when a new client has to be inputted. I hope someone can help me with this.

Thanks

[DonRayner]

As in the example that I added below, your "Add new record" command button would have to set the focus to the subform that you want to work with before running the new record command.

Forms!MainForm.Form!SubForm.SetFocus
DoCmd.GoToRecord , , acNewRec

[menkenk]

Thanks for the help DonRayner. Much appreciated.

[DonRayner]

@menkenk
You're quite welcome Menkenk. And Welcome to Bytes.