Wierd freeeze up after searching form.recordset.clone

M

Marcus Smaby

I have a simple database linked to a SQL 2000 backend. On one form, I have a
drop-down that finds a record via the after-update on the combo box

Sub Combo130_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo130]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

This works perfectly - and I can edit the found record. However, when I try
to navigate away, or save this record I get long wait and and error msg:

ODBC--update on a linked table 'CPCO' failed.

[Microsoft][ODBC SQL Server Driver]Timeout expired (#0)

However, if I never use the search dropdown, merely navigate with the back
and forward buttons, then I can edit and save all day long. How can
accessing the RecordsetClone lock this all up??

Thanks

Marcus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC Update on a linked table 'table name' failed 1
recordsetclone does not update form display 2
Record Selectors VS Combo Box Record Selector 4
Duplicate record in Form and Subform 0
Can not pull up record with combo box 10
Copy Record Problem 3
Filter in header affects find record combo 4
ComboBox Search with Like 2

Top