Force New Record with Data Entry to YES!?!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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???
 
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!
 
Back
Top