Code breaking with no breakpoint

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top