I have a problem that has been playing havoc for a day and would
appreciate any help. The problem is I am getting the above error
whenever the following code is executed after installing the program.
There are no errors when run under the IDE or running the program's exe
file - only if the program is packaged and installed. I use error
handling and break on all errors.
Me.chkExternalPgm.Value = rsSubInfo!MapExtPgm
chkExternalPgm is a check box on a form that gets a value from the
recordset field MapExtPgm, which is an integer field. The default value
of the field is 0, and in using both break points and examining the db
it truly is zero the first time through.
Before I the field was being set to 0 when the record was created, there
was the possibility that it may be a null, so I used this code and got
the same results.
If (IsNull(rsSubInfo!MapExtPgm)) Then
Me.chkExternalPgm.Value = 0
Else
Me.chkExternalPgm.Value = rsSubInfo!MapExtPgm
End If
Debugging run time errors is very fustrating, so any advice is welcome.
Dennis,