Recordset question

[Kicker]

using Access 2007

If I have to use a bound form, I will. However, I would much prefer to create a recordset and go from there. Been using VB6 for years and am must use Access 2007 for one project and 2002 for another. Go figure.

I need to cycle through recordsets, filter them, etc.

I'l leave this one up to you guys. You have never failed me yet.

[Bob Phillips]

But what are you trying to do? You state how you want to do it, but not what it is.

[CreganTur]

If the data you want to work with is the same database, or linked to the database where your forms are, then it's easier to use bound form and filter on your form.

If you're dealing with an external database, then you would need to look into DAO (Data Access Objects) or ADO (Active-X Data Objects) to make a connection to the external recordset.

xld is correct- we don't have enough information to do anything other than offer you nearly-empty generalities.