Force New Record with Data Entry to YES!?!

[Guest]

I just added a filter in the header section of my main form to sort out
active vs. inactive students. In doing so I noticed that my subform for
student notes no longer forces the new record to appear. It used to be blank
and old notes only showed on a nested subform. Now the last note entered
shows on the main form eventhough Data Entry is set to Yes and I have tried
several event proceedures to force a new record to appear, such as

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

Any Suggestions???

 

[Guest]

I fixed it!

Went to DATA tab under subform properties and then went into Record Source.
I just set the Note field to IsNull and that solved the problem of previous
notes showing up on the subform. I also removed the navagation buttons so
teachers can only enter new notes and are forced to open "view all notes" on
the nested subform.

Hope it helps someone else!