dataenvironments

i have created a dataenvironment and i can navigate through it no problem

dataenvironment1.rsplayers.movenext
if dataenvironment1.rsplayers.eof then
dataenvironment1.rsplayers.movefirst

etc

i need a button that can add data entered into text boxes into the database ??

thanks in advance

If you have the Professional Edition, you can use the data aware form wizard to create text boxes connected to your recordset. You can also set the data source and field properties of your textboxes.

Try something like this... :)

Code:

---

dataenvironment1.rsplayers.addnew
dataenvironment1.rsplayers!fieldname = Text1.Text
dataenvironment1.rsplayers!fieldname = Text2.Text
dataenvironment1.rsplayers!fieldname = Text3.Text
dataenvironment1.rsplayers.Update

---

thanks, i havnt tested ywt as im at work but i had something simular with slightly wrong syntax, i knew it was easy i have done things like it in the past but i have had a lot of problems with connecting to my database since sp2 really

ps i have the enterprise edition


ill resolve it when ive test :d