[sogeking]

Private Sub cmdadd_Click()
DataEnvironment1.Add Text1.Text, Text2.Text, Text3.Text, Text4.Text, Text5.Text, Text6.Text
MsgBox "sucessfully saved"
End Sub

[Martyr2]

If you are trying to save textbox data to a database, you don't directly try to add it to the dataenvironment object. The dataenvironment holds other objects like the connection object which you can then use to save data with.

Look into using the ADO connection and recordset objects. Read a bit about them here and then check out the method AddNew example for a full example of how all this works.

In the future please provide a little more story as to what you are trying to accomplish. Just posting a few lines of code isn't going to get you anywhere on most boards. Luckily I try to take the time to answer things like this from time to time.

Good luck to you.