URGENT: Help Required!

[THCi]

Right, my VB project has gotta be in in the morning, and Im having some trouble with a recordset, adding a new record to be precise.

Im trying to use this code:

Private Sub cmdAddResToDb_Click()

'' Add new record to set
Data1.Recordset.AddNew


'' Split TxtOut into an array
s = Split(txtOut.Text, "|")

'' Put Data into Fields
Text2.Text = Dir1.Path
Text1.Text = s(1) ''FileName
Text3.Text = s(1) ''Path

'' Update set
Data1.Recordset.edit

End Sub

I cant add a new record to a recordset, all it keeps doing is editing the current one. Nothing else in the form using the recordset, also the recordset is being generated from a Data control hidden in the form. Could that have a part to do with this error?

Thanks for any help,

Nath'

[Knoxville]

I've not actually done this as im planning to resit next year but the code i've been using to help the first years all morning is -

Private Sub cmdadd_Click()
Data1.Recordset.AddNew
Text1.Text.SetFocus
End Sub

It doesn't deal with arrays, because i can't remember how to deal with em when adding a new record. Can't be of anymore help atm man as im knackered and about to retire to bed.

[THCi]

its ok dude, retire at will!

[THCi]

Nm folks, got it licked now...

Feel like a right dumbass now as well

All that was required was Data1.Recordset.edit to be changed to .Update!