RecordsetClone

[JethroUK©]

With RecordsetClone
.MoveFirst
.Find "[Ni No]= " & NI_NO 'Error - Object doesn't support
this (FIND) property ????????

Does Recordsetclone support 'find' method?

I also notice the Recordsetclone doesn't prompt for methods/properties which
makes me suspect missing refernce

Any ideas which refernce support recordsetclone?

 

[Ken Snell \(MVP\)]

RecordsetClone is a DAO recordset. Try using FindFirst, etc.

 

[JethroUK©]

That worked thanks - i still figure i have refernce issue - any ideas why
recordsetclone. doesn't prompt for parameters?

RecordsetClone is a DAO recordset. Try using FindFirst, etc.

--

Ken Snell
<MS ACCESS MVP>

With RecordsetClone
.MoveFirst
.Find "[Ni No]= " & NI_NO 'Error - Object doesn't support
this (FIND) property ????????

Does Recordsetclone support 'find' method?

I also notice the Recordsetclone doesn't prompt for methods/properties
which
makes me suspect missing refernce

Any ideas which refernce support recordsetclone?

 

[Dirk Goldgar]

That worked thanks - i still figure i have refernce issue - any ideas
why recordsetclone. doesn't prompt for parameters?

In Access 2000 and later, the form's RecordsetClone property returns a
value of type Object, not specifically DAO.Recordset nor
ADODB.Recordset. Therefore, the VB Editor doesn't know the properties
and methods that belong to this object. The RecordsetClone property is
defined this way because a form's recordset (and hence its clone) might
be either a DAO Recordset or an ADODB Recordset, depending on whether
the form is in an MDB or an ADP file.