recordset.FindFirst

[Guest]

the FindFirst is not working, I can't see anything wrong. I am trying to get
bound combo boxes to show the record I am searching for.

Debug.Pring shows strSearch is:

(VehLicence = "321abc") AND (VehYear = 1990) AND (VehMake = "AMC")

(VehLicence and VehicleMake are of type string and year is number)
below is my code, any help would be appreciated.

Dim rs As Object
Dim strSearch As String
Set rs = Me.Recordset.Clone

strSearch = MakeSearchString ' programmer defined function
rs.FindFirst strSearch
Me.Bookmark = rs.Bookmark

PS. When I try to exit I am also getting an error message "Update or
cancel update without addnew or edit"

 

[kingston via AccessMonster.com]

This is because you've only got ADO methods available and you're trying to
use a DAO method. Yes, it's confusing. Use .MoveFirst and then .Find
instead.