Trouble with Me.RecordsetClone!!! (1 Viewer)

[muratas2]

Hi,
I have below sub on the click event of a command button on a form which has a query as a Record Source.

Dim rst as Recordset
set rst = Me.RecordsetClone

On the secont line I received " Run Time Error 13 - Type Mismatch "

Why can it be? I saw many similar codes in some books...

Please help, thanks

Murat

 

[R. Hicks]

There is not any problem with the two lines of code. Your code may only be stopping on the second line but the problem must be after the second line. Post the rest of the sub for us to see.

RDH

 

[Travis]

You may need to check to make sure your references are set (especially if you are using Access 2000).

 

[Danielf]

I have the same problem as Muratas 2.
Which references should be set?

Thanks for answer.

Daniel