Blueice13085
asked on
MS Access ADD New Record Help!
I have a form called frmCallTypes with a subform called frmCallTypePrices on the main form i have a cmd button called cmdAddRec i want it to on click add on record for the main form and add 3 records for the subform with values placed in each record that is added below works if i have a cmd button on the subform
but again i dont want a button on the subform i want it on the main form, and it needs to add on blank record for the main form and the listed above for the subform. thank you
Private Sub cmdAddRec_Click()
On Error GoTo Err_cmdAddRec_Click
DoCmd.GoToRecord , , acNewRec
Me.StartTime = "12:00:00 AM"
Me.EndTime = "7:59:59 AM"
DoCmd.GoToRecord , , acNewRec
Me.StartTime = "8:00:00 AM"
Me.EndTime = "4:59:59 PM"
DoCmd.GoToRecord , , acNewRec
Me.StartTime = "5:00:00 PM"
Me.EndTime = "11:59:59 PM"
Exit_cmdAddRec_Click:
Exit Sub
Err_cmdAddRec_Click:
MsgBox Err.Description
Resume Exit_cmdAddRec_Click
End Sub
but again i dont want a button on the subform i want it on the main form, and it needs to add on blank record for the main form and the listed above for the subform. thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER