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?
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?