error 3251 from recordsetclone

[st3ve]

I am using the code RecordSetClone = "NPDAllRemovals" , to change the source of records (ie I want to point at table NPDAllRemovals, now) to pull up to a form. When I do this I get:

'RunTime error 3251 - Operation is not supported for this type of object'.

The 'recordsetclone pointer'needs to be synchronized with the contents of combobox cboSourceChoice (NPDAllRemovals).
I have also tried ...
Me.RecordsetClone = Me.cboSourceChoice ... with the same result.

How do I get the recordsetclone to point at the right table?

 

[retro]

I personally don't know the answer, sorry.

Try this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;207836

 

[retro]

You might also try...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacchbk/html/acsybex_chap6.asp

"For table-type recordsets, you can specify the ordering by setting the Index property. (Access does not allow you to set the Index property of any other type of recordset. Attempting to do so will only get you runtime error 3251, "The operation requested by the application is not supported by the provider.") As soon as you set that property, the rows appear in their new ordering."