Moving to record in form using RecordsetClone

A

Andy G

I use this code to have the form move to the record in the combo box. This
works once and then give me an error. Weird. The form is bound to query
that joins 5 tables. It errors on the first line of this code and the error
is:



Run-time error '7951':

You entered an expression that has an invalid reference to the
RecordsetClone property.


This code is fired 'After Update' on the cmbCourse dropdown...

'Move to the record selected in the cmbCourse box
Me.RecordsetClone.FindFirst "[CRSE_ID] = " & Me.cmbCourse
Me.Bookmark = Me.RecordsetClone.Bookmark


Any ideas?
 

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

Top