Run-Time Error 2427 (1 Viewer)

I am encountering Run-time error 2427 "You entered an expression that has no value". The line in bold below is the line causing the issue.

The txtcount field on the form is =Count([tbldetails.CustomerNumber])
there are two identically name fields in two tables, hence why the table name is at the front. Not sure if this where the error lies.


Option Compare Database
Private Sub btnsendemail_Click()

If Me.txtcount = "" Then
MsgBox "There are no actions to be undertaken"
Else
On Error GoTo handdler

Regards
Trisha

How about:

If IsNull(Me.txtcount) Then

?

[tbldetails].[customernumber] is the correct formatting for specifying a table and column-name.

Hi

Thanks for that. The error has stopped popping up but now nothing happens at all when the button that the VBA associated to is clicked. Macros are enabled and other buttons on the page work fine.


Regards
Trisha

Stick a breakpoint on the code behind the button (F9 or click in the margin where you want the code to break) step through it line at a time (F8 in the IDE) and have a look at the values that your code is depending on as it runs. The Locals and Watch windows are helpful at this point to keep tabs on what values your variables currently represent.

Your test on the count, for example, is looking for "" but the count should be returning 0 if there are no records so the test should never be true.

If your code snippet is indicative, I'd also recommend adding


To your modules along with Option Compare Database, it makes bug fixing much easier as it'll pick up issues along the lines of:

Thanks the error is no longer appearing.