Create New Record On Form And Subform Simultaneously

**mikael** · 08-04-2012, 08:09 AM

i have a project that combine 1 mainform with 3 subform in a form.. the problem is i need to have only one new record button in a mainform that can move to new record of the mainform and these 3 subform.. i really dnt know the code to combine the 4 forms to make new record. i wish to know where to code this button. i hope the new record button could make these 4 forms to new blank form. can anyone pls help me.. thank you.. sorry for my poor english

**Missinglinq** · 08-04-2012, 08:54 AM

In the Code Module for each of the Forms that the Subforms are based on, place this code:

Code:

Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec End Sub

Linq ;0)>

**mikael** · 08-04-2012, 09:30 PM

thanks ... it work for me now..

**Missinglinq** · 08-04-2012, 10:06 PM

Glad we could help!

Linq ;0)>

Create New Record On Form And Subform Simultaneously

Thread Tools

Create New Record On Form And Subform Simultaneously

Similar Threads

Create multiple records/fields simultaneously

Create a combo to fetch record in a subform

Create new record in subform

Create combo search form in subform

Create PDF for each record in table/form

Posting Permissions