RecordSetClone

[matttt]

I copied a navigation button routine from a book which starts

Dim recClone As RecordSet
Set recClone = Me.RecordSetClone

When I run just this code I get "Error 13 - type mismatch error. However if I download the program from the CD accompanying the book and delete everything but this code it runs fine.

If I export or paste the form (with code) from one Access environment to the other, it always works in one and never in the other, indicating this is not a typo error

Can any one help??

 

[Rupert57]

If you’ve got two different “Accesses” working, then one could have missing references.
Open, or create a form, in design mode, select code, >Tools>>>References, have a look to see if any are marked “Missing” also see if you have the same selected in each Access.

Also it’s a good idea to change this line:- Dim recClone As RecordSet

To this:- Dim recClone As DAO.RecordSet

 

[matttt]

Many thanks
I added the DAO 3.6 library, and it now works fine.

 

[ATB]

Same Problem

I am having the same problem, I have tried adding the DOA 3.6 as suggested but still get the same error as above.

if i add the Doa.recrodset code as detailed above the error stops bu the code doesn't seem to work.

any oher ideas would be welcome.

Cheers