The current event in my form is executing before the Open event. As far as
I understand it the "open" event is supposed to be the first place you can
put code. I sort of think this wasn't happening earlier. I've compact and
repaired the database. Any advice?

Private Sub Form_Open(Cancel As Integer)
ls_Debug = "stop" 'Here is my
break point
Set irst_StudentTracking = Me.Recordset 'And another is here
End Sub

"LAS" <(E-Mail Removed)> wrote in
news:i3jp4f$l0j$(E-Mail Removed):

> The current event in my form is executing before the Open event.
> As far as I understand it the "open" event is supposed to be the
> first place you can put code. I sort of think this wasn't
> happening earlier. I've compact and repaired the database. Any
> advice?
>
> Private Sub Form_Open(Cancel As Integer)
> ls_Debug = "stop" 'Here
> is my
> break point
> Set irst_StudentTracking = Me.Recordset 'And another is
> here
> End Sub

Again, why are you bothering with the form's recordset when the
whole point of a form is to edit the data via the form's controls?

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/