"No value" errror

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How does one test for 'no value', as in runtime error 2427 "You entered an
expression that has no value"?

Tried IsNull, IsMissing and IsEmpty, but processing just skips right by.

I am giving people the ability to move an entry from a subform list, but
occasionally the subform list is already empty. I want to control what
happens if some bozo clicks the 'move' button on an empty list, but all
attempts to test if the subform control has no value, as in the following code

If IsMissing(Me.SubAreaList!SubareaID) Then
msgbox "There is no selected subarea to move"
GoTo Exit_cmdMoveSubarea_Click
End If

As I mentioned above, ismissing, isnull and isempty all fail to detect the
'no value' problem in this example.

Any ideas how to detect the empty list, short of querying the database with
the list conditions to see if anything is on the list?

Thanks in advance to anyone that has an idea how to trst for this condition.

Fred
 
Fredrated said:
How does one test for 'no value', as in runtime error 2427 "You entered an
expression that has no value"?

Tried IsNull, IsMissing and IsEmpty, but processing just skips right by.

I am giving people the ability to move an entry from a subform list, but
occasionally the subform list is already empty. I want to control what
happens if some bozo clicks the 'move' button on an empty list, but all
attempts to test if the subform control has no value, as in the following code

If IsMissing(Me.SubAreaList!SubareaID) Then
msgbox "There is no selected subarea to move"
GoTo Exit_cmdMoveSubarea_Click
End If

As I mentioned above, ismissing, isnull and isempty all fail to detect the
'no value' problem in this example.

Any ideas how to detect the empty list, short of querying the database with
the list conditions to see if anything is on the list?
Click to expand...


You need to test for the no record situation instead of
testing for the non-existent value:

If Me.SubAreaList.RecordsetClone.RecordCount = 0 Then
 
Back
Top