Okay it's bringing it up, but if the value for the field is empty then it will error out
Is there any way to account for it?
I'm using like:
Code:
If rs!ReturnNumber = Null Then
If rs!ReturnNumber = 0 Then
If rs!ReturnNumber = ""
Me.txtReturnNumber = 0
End If
Me.txtReturnNumber = 0
End If
Me.txtReturnNumber = 0
Else
Me.txtReturnNumber = rs!ReturnNumber
End if
but for some reason it isn't wanting to do what I need it to . Thanks for the help so far!
EDIT: The reason I wrote the if statement was because if I just put:
Code:
Me.txtReturnNumber = rs!ReturnNumber
and the field for that entry was empty, it would error as well.
EDIT2: I read on the help file that it treats a null as a false, so when I put in False instead of Null in the if statement above it says that the following code has an error:
Code:
Set rs = db.OpenRecordset("Select * FROM TrackingTable WHERE [LookupNumber] = " & Me.[txtLookupNumber])
I've also tried
Code:
If IsNull(rs!ReturnNumber) = True Then
Me.txtReturnNumber = 0
Else
Me.txtReturnNumber = rs!ReturnNumber
End if
and
Code:
If IsNull(rs![ReturnNumber]) = True Then
Me.txtReturnNumber = 0
Else
Me.txtReturnNumber = rs!ReturnNumber
End if
and
Code:
If IsNull([ReturnNumber]) = True Then
Me.txtReturnNumber = 0
Else
Me.txtReturnNumber = rs!ReturnNumber
End if
to no avail.