setting a Recordset to form with recordsetclone

[raygahan]

Have problem getting Recordset to load from form,
would also like to know if I source a recordset from a table
and filter it, how can I load those records into an open form.

Private Sub Command6_Click()
Dim db As DAO.Database
Dim Rst As Recordset
 
     Me!Address.SetFocus  'this works but
 
     Set Rst.Source = Me.RecordsetClone
            'gives error Object Variable BlockVar not set>

[MMcCarthy]

Have problem getting Recordset to load from form,
would also like to know if I source a recordset from a table
and filter it, how can I load those records into an open form.

Private Sub Command6_Click()
Dim db As DAO.Database
Dim Rst As Recordset
 
     Me!Address.SetFocus  'this works but
 
     Set Rst.Source = Me.RecordsetClone
            'gives error Object Variable BlockVar not set>

To load recordset from a form ...

      Set Rst = Me.RecordsetClone

Mary

[raygahan]

To load recordset from a form ...

      Set Rst = Me.RecordsetClone

Mary

Thanks On one machine this line works,
on the other one I am getting an error "type mismatch"
Could this be a problem with this particular form or just a corruption.

[MMcCarthy]

Thanks On one machine this line works,
on the other one I am getting an error "type mismatch"
Could this be a problem with this particular form or just a corruption.

The machine giving the type mismatch error is probably missing the DAO library. Go to Tools - References and make sure the Microsoft DAO library is ticked.

Mary