By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,273 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

setting a Recordset to form with recordsetclone

P: 2
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.



Expand|Select|Wrap|Line Numbers
  1. Private Sub Command6_Click()
  2. Dim db As DAO.Database
  3. Dim Rst As Recordset
  4.  
  5.      Me!Address.SetFocus  'this works but
  6.  
  7.      Set Rst.Source = Me.RecordsetClone
  8.             'gives error Object Variable BlockVar not set>
Dec 19 '06 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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.



Expand|Select|Wrap|Line Numbers
  1. Private Sub Command6_Click()
  2. Dim db As DAO.Database
  3. Dim Rst As Recordset
  4.  
  5.      Me!Address.SetFocus  'this works but
  6.  
  7.      Set Rst.Source = Me.RecordsetClone
  8.             'gives error Object Variable BlockVar not set>
To load recordset from a form ...

Expand|Select|Wrap|Line Numbers
  1.       Set Rst = Me.RecordsetClone
Mary
Dec 19 '06 #2

P: 2
To load recordset from a form ...

Expand|Select|Wrap|Line Numbers
  1.       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.
Dec 19 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Dec 19 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.