Code breaking with no breakpoint

  • Thread starter Thread starter Amy Blankenship
  • Start date Start date
A

Amy Blankenship

Hi, all;

I have a database split into FE/BE to make it easier for someone else to
enter data while I work on the logic of the forms and queries. Recently,
when the main "Edit stuff" form opens, the code breaks on one of the lines
in the Current event procedure for the highest level subform as if there
were a break point there, but there isn't. If you press the "play" button,
the form opens just fine.

This is the event procedure:

Private Sub Form_Current()
Me.CategoryOrder.DefaultValue = Me.CurrentRecord
Debug.Print (DCount("CategoryID", "CategoryScoreSet", "CategoryID=" &
Me.CategoryID))
If DCount("CategoryID", "CategoryScoreSet", "CategoryID=" &
Me.CategoryID) > 0 Then
ImportScale.Enabled = False
Else
ImportScale.Enabled = True
End If
End Sub

It breaks on the line that starts If DCount...

Any ideas?

TIA;

Amy
 
Back
Top