Something causing access to crash

[penfold1992]

So, my database appeared to be working OK yesterday however I occasionally saw an error in my "Update Event" script on one of my combo boxes.

today, now when I try the combo box, I get a immediate crash.
If im assuming its the same combo box, here is the code for that box:

Private Sub MCAcmb_AfterUpdate()
Me.Model.RowSource = "SELECT DISTINCT [tbl].Record, [tbl].Model" & _
                           " FROM [tbl]  WHERE Record = '" & Me.Recordcmb.Value & _
                           "' ORDER BY Model"
 
Me.Makecmb.Value = Null
Me.Modelcmb.Value = Null
Me.Makecmb.Enabled = (Not IsNull(Me.MCAcmb))
Me.Modelcmb.Enabled = (Not IsNull(Me.Suppliercmb))
End Sub

I recently added a header... thats the only thing i can think of that has contributed to this issue...

EDIT: just tried it again and got the error:
"The expression After Update you entered as the event property setting produced the following error:Object or class does not support the set of events."
however I got it to work by entering VB, adding a space, removing it and then saving and entering the form view.... the form worked as normal... when i close and reload, i get the error again

 

[aziz rasul]

Have you tried compiling the database?

 

[penfold1992]

im using a new version of access... in 2003 there was a compile database but i cant seem to find it... where should i be looking?

 

[pr2-eugin]

To compile a DB.. Go to the VBA Window, Debug Menu->Compile.. Try stepping through the code to exactly find where you get the error..