I thought that if I used a data environment I'd be able to share data
accross the forms better, and this works really well.  But how do you
add new records?

I have an Access table with VidID, VideoTitle, and DatePurchased in it
and I want to add another from a VB Form.  There is also a auto-inc
field as the first column in the table called ID.

In the data environment, I have a connection which is linked to my DSN
source VideoDB, which I set up in ODBC (32 bit) in the control panel.
Next I set up a command as an object under my connection.  I changed
it to a table type command with the table AllVideos.  But if I do an
dataenvironment1.rscommand1.addnew I get an error saying 'invalid or
unreferenced qualifier.'  Now, I'm not sure I'm doing this entirely
right...but I am going by example code in the docs.  here's what I
have...

Private Sub cmdAddNewVideo_Click()
  envVideoConnection.rsVideoTable.AddNew
    !VidID = txtVidID.Text
    !VideoTitle = txtVideoTitle.Text
    !DatePurchased = txtDatePurchased.Text
End Sub

Should I be putting something in for the auto-inc field?  What causes
this error to pop up?  Am I calling AddNew wrong?

Thanks for any help.

<ChipOne>

Make sure that the LockType property of the command is not
adLockReadOnly.  Also put the Update method after you set the values in
order to save your data.
    Private Sub cmdAddNewVideo_Click()
        With envVideoConnection.rsVideoTable
            .AddNew
            !VidID = txtVidID.Text
            !VideoTitle = txtVideoTitle.Text
            !DatePurchased = txtDatePurchased.Text
            .Update
        End With
    End Sub

If this still doesn't work, put # signs on either side of the date
    !DatePurchased = "#" & txtDatePurchased.Text & "#"

Matt Ridge