ChrisB

Access 2000 DB.

Dbl Click event for a list box...

Private Sub lstCalls_DblClick(Cancel As Integer)

Dim rst As Recordset

Set rst = Forms!frmCallIndex.RecordsetClone

I get a run-time error 7951 on the Set RST line "You entered an expression that has an invalid reference to the RecordsetClone property"

Using Me. instead of forms! gives the same problem

MS's own demo code suggest this should work...

Sub Print_Field_Names()

Dim rst As Recordset, intI As Integer
Dim fld As Field

Set rst = Me.RecordsetClone

Win 2000 Pro on my PC, Office 2000 Pro SP1.

Same problem in this DB on my laptop running XP Pro and Office 2000 Pro SP1.

I've compressed and repaired the database. I've exported all the forms etc into a new DB.

Nada, zip, nothing.

Thoughts?