sub form help

[amna77]

Hi I am trying to save values in my sub form. actually on mu sub form i am keeping the date. when ever user enter date in the main form it gets in to subform date. thats what i want.
Forms!frmCMMDataEntry!Form1!Date = Me.Date
but the thing is when i add new record on main form, then sub form values does not save. i tried to add codes on the main form add new record button.

DoCmd.GoToRecord , , acNewRec
DoCmd.Save acForm, "Form1"
but it gives me error. anyidea whats wrong.
thanks

 

[BrianB]

I am not too familiar with MS Access macros, however the principle is that if you wish to keep values in a form you need to Hide it rather than close it.

So in a code module I might put something like this to hide Form2 and show Form1. There would be simlar code in Form1 to do the reverse.
Hope this helps.

'- in Form2
Private Sub Command1_Click()
    Me.Visible = False
    Forms("form1").Visible = True ' needs to be open already
End Sub