var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: setting bookmark
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:
when a user tries to search for a product, it finds it and sets the current record properly.
Me.RecordsetClone.FindFirst = "id= " & productID
Me.Bookmark = Me.RecordsetClone.Bookmark
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?