recordset in vba

[lamha]

I haven't done Access programming for so long and I forget even the most basic thing on how to open a recordset in vba. I need to open a table and select certain records. Are there 2 ways to do that? Which way is better? How do you write codes to create and open a recordset?
I'm using Access 2003.
Thanks.

 

[KeithG]

Why do you want to open a recordset with VBA? Why not just set the control source of your form to query that selects your records?

 

[lamha]

That's because I need to open more than 1 queries (diff. tables) in the form.