Blank ADO recordset for unbound form

[perrymans]

How do you call a blank recordset to add a record, into an unbound form? (Using ADO and no continuous connection to the backend)

Thanks. Sean.

 

[PHV]

Are you talking about the AddNew method of the ADODB.Recordset object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[me2you]

You can use the ADO object model to create a disconnected record set, after which you can programmatically link each unbound field in your form to a field in the disconnected record set. You can then save the record set to a flat file.

Hope this works.

Peace,

me2you