adding record to subform

[awelch]

I am trying to update/insert a new record into a sub-form based on new information from the main form. Each change needs to create a new row in the subform section of the form.

here is the code for my refresh button that should insert the record.

Private Sub cmdRefresh_Click()

   DoCmd.DoMenuItem acFormBar, acRecordsMenu, acAddRecord, , AcMenuVer70

Exit_cmdRefresh_Click:
   Exit Sub
Err_cmdRefresh_Click:
   MsgBox Err.Description
   Resume Exit_cmdRefresh_Click

Exit Sub

Thanks for any assistance.

awelch

 

[sfm6s524]

Might want to try making the subform the active control before adding the record:

Me![SubFormName].Setfocus
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acAddRecord, , AcMenuVer70

Ken