ADO Stuff

[damann]

Hey guys,

I have an opened recordset that is already connected to a database called conn. I want to add data from a form to this recordset. Which would be the correct way of doing this?

1. conn("Date&quot = yr
2. conn.Fields("Date&quot = yr
3. conn.Field("Date&quot = yr

Explain.

Thank you,
Damman

 

[damann]

sorry guys, the "recordset" is called conn not the database...

 

[IonelBurtan]

First you got to do an addnew like:

conn.AddNew
conn.Fields("Date&quot.Value = yr
conn.Update

set conn = nothing
....

The CursorType of your reccordset must be adopenKeyset or adOpenDynaset.

Good luck, s-)

Blessed is he who in the name of justice and goodwill, sheperds the weak through the valley of darkness...

http://www20.brinkster.com/ionelb