Compiling Problem

[Scott]

After I compile my database, events will not run the code i have made. Does
anyone know whay this happens? ex.
Private Sub County_Enter()
On Error Resume Next
County.RowSource = "Select Counties.County " & _
"FROM Counties " & _
"WHERE Counties.State = '" & State.Value & "' " & _
"ORDER BY Counties.County;"
End Sub

I made these combo boxes to narrow the the list of counties based on the
value of the "State" combo box. This wortks fine until i create the accde and
then it will not work. Why does the code not run?
Thanks