Filter By Form - Recordset 1

[Basia]

Greetings. I currently have a form that allows users to Filter by Form on a customized tool bar. Everything works great. From this form users can filter records that they want and then open up another form which allow them to create an email to be sent to all the records in the filtered recordset.

My problem is that I do not know how to loop through this recordset created by filter-by-form. How do I refer to it?

Dim rst as recordset

set rst = ???? (I was using me!filter, but does not work)

Any help is MUCH appreciated!

Thanks...Basia

 

[seaport]

Use the following code
***
Dim rst as dao.recordset

set rst = me.recordsetclone
***

If you apply a filter to the form, the filter is also applied to the recordsetclone.

Seaport

 

[Basia]

Thanks for the response. When I try it, I get an error:

"User defined type not defined."

Do I need to check off DAO under some option?

Let me know...Basia

 

[seaport]

OK, I believe you are using Access2000, which use ADO as the default data access object model. All you need to do is to add DAO to the reference of your database. In the VB editor, go to Tools-Reference to add "Microsoft DAO 3.6 Object Model," then the code should run OK.


Seaport

 

[Basia]

Thank you so much! Works great.

Basia