Getting Records after filtering

N

Nicozz

Hi,
i working on an application based upon Access 2003.

I have to fill a table with records resulting from the filtering of a
simple form.
Let's say i want to recover the whole records (let's say twenty) and 2
fields out of five (let's say the 2nd and 3rd one).
I tried to loop over a recordset but it ain't looping at all !!
Did anyone already done that before ?

xpost + fu2 c.d.ms-access
 
M

Mike Napthine

If you want to create a table and populate it with data, the best thing would
be to use a "Make table" query, you can apply all sorts of filters to choose
records, select any fields your require and no need to worry about
recordsets! This can then be automated with the "OpenQuery" statement in a
macro or docmd.openquery in VB.
 
Top