RECORDSET RETURNING FALSE VALUE

[dk]

I need little help from Your side. I have DB to tracking complains of the
owners of the vehicles.
If form NewComplain user shall imput VIN number of the vehicle. In table
Vehicles I have fields Chassis and field OWNER. I using following code to
fill-up field OWNER

Private Sub VIN_LostFocus()

Set db = CurrentDb()
Set rst = db.OpenRecordset("Vehicles", dbOpenDynaset)
rst.FindLast "Chassis = '" & VIN & "'"

Me.OWNER = rst.OWNER
rst.Close
End Sub

The problem is if there is no mach, rst returns some vromg value into field
OWNER.

Thank You very much to help me resolve this.

Regards,
DK

 

[Allen Browne]

You need to test NoMatch after the FindFirst:

rst.FindFirst ...
If rst.NoMatch Then
Me.OWNER = Null
Else
Me.OWNERj = rst!OWNER
End If

 

[dk]

THNX
this pice of code were missing !
DK

You need to test NoMatch after the FindFirst:

rst.FindFirst ...
If rst.NoMatch Then
Me.OWNER = Null
Else
Me.OWNERj = rst!OWNER
End If