I have an access front end with odbc table links to a sql server backend.

I have a form which lists products which is displayed as continous form.
at the top of the form, i have a combobox which allows users to search for a specific record.

The code to find the product is as follows:
Me.RecordsetClone.FindFirst = "id= " & productID
Me.Bookmark = Me.RecordsetClone.Bookmark
when a user tries to search for a product, it finds it and sets the current record properly.
However, when they try to edit it, sql server times out.

I should note that if the user finds the prodcut by scrolling up/down and edits it, it updates fine.

I ran sql profiler and checked the sql statement from both scenarios, they are identical.

Is it the bookmark? Anyone else experienced this?