> I have a function that finds a customer.When the customer does not
> exist, i get the error not a valid bookmark.
[quoted text clipped - 19 lines]
>
> End Function
This line is the source of the problem:
> f.Bookmark = strBookmark
It serves no purpose anyway, and should just be deleted.
You'd do well to rewrite the last bit slightly, to access the
RecordsetClone property only once, like this:
With f.RecordsetClone
.FindFirst "CustomerID = " & strCustomerID
If .NoMatch Then
MsgBox "customer " & strCustomerID & " does not exist!!"
Else
f.Bookmark = .Bookmark
End If
End With

Signature
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)