can you populate table from recordset??

[thewiseguy]

hello there,

just curious if it was possible to populate an empty tables' fields from a recordset that had been defined earlier in VBA under the criteria of a bit of sql code?

cheers.

 

[namliam]

Yes can....

Simply create a second recordset in VBA and fill the table with the data retrieved....

Regardz

 

[thewiseguy]

much appreciated -
i'll get right on it...