Setting a Recordsetclone with DAO

A

Altemir

Why do I keep getting a type mismatch error with the following
statements? I have "Microsoft DAO 3.6 Object Library" established as a
reference under the Tools menu but it still doesn't work.

Dim rst As DAO.Recordset
Set rst = Forms!frmPOList.RecordsetClone

Note that I am setting this recordsetclone for frmPOList from another
form. Is that a problem?
 
W

Wayne Morgan

I just tried this and it does work without an error. Is frmPOList open? Does
it have any records?
 
A

Altemir

frmPOList is not a sub form. There must be something I'm not telling
you, but I don't know what it is. I'll keep trying!!

Thanks.
 
D

Dirk Goldgar

Altemir said:
frmPOList is not a sub form. There must be something I'm not telling
you, but I don't know what it is. I'll keep trying!!
Click to expand...

This isn't in an ADP, by any chance, is it?
 
Top