Solved Runtime Error 13 Type Mismatch (1 Viewer)

[LanaR]

I must be missing something very basis as the following is throwing a Runtime Error 13 Type Mismatch

Dim rst As Recordset

Set rst = Me.RecordsetClone

On the Set command

The code is in the On Click event of a button

 

[MajP]

dim rst as dao.recordset

it is probably dimensioning it as and ADODB.recordset and the form returns a dao recordset thus a type mismatch.

 

[LanaR]

Thanks that did the trick