Transfering Data to Databases

[MKayHavoc]

I am using a DAO data control linking to an Access 2003 database. I have been extracting information already within the database using the following method:

txtName.Text = datMembersDetails.Recordset("MembersForename")

And this works fine. However it doesn't work the other way round:

datMembersDetails.Recordset("MembersForename") = txtName.Text

I am wanting to add data that the user has inputted into the text box into the table.

I am using the add new command before this command e.g:

datMembersDetails.Recordset.AddNew
datMembersDetails.Recordset("MembersForename") = txtName.Text
datMembersDetails.Recordset("MembersSurname") = txtName2.Text

However this doesn't work. What am I doing wrong?

Cheers
Ryan

[Phil Weber]

How are you creating the recordset?

[MKayHavoc]

I have a data control with database set to my database location and recordsource set to a query in the database and that's it.

Not sure exactly what you mean?

[Phil Weber]

What's the query? What is the value of the data control's RecordsetType property?

[MKayHavoc]

The query just pulls 5 fields from two tables, there are no expressions etc. And the RecordsetType is set to Dynaset I think.

[pclement]

Don't you need to call the Update method:

datMembersDetails.Recordset.AddNew
datMembersDetails.Recordset("MembersForename") = txtName.Text
datMembersDetails.Recordset("MembersSurname") = txtName2.Text
datMembersDetails.Recordset.Update

[Phil Weber]

In addition to Paul's suggestion, if the query pulls data from more than one table in a "one-to-many" relationship, the recordset is not updateable.

[MKayHavoc]

Cheers for the suggestions guys. Ended up finding a different solution that achieves the same results.