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:
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?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
Thanks for any help,
Nath'


LinkBack URL
About LinkBacks

Reply With Quote
