Hi,

How do I make a copy of a recordset with just the field names in it without any data?

I tried the Clone method but it does not seems to work with a declared recordset and a recordset from a Data control.

This is the code I used:

Dim rs as Recordset
set rs.Clone = Data1.Recordset

Thanks in advance.