After Adding New Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In VB code I open a table which has records in it and add new records to this
table. After I've completed adding the new records, I go to the last record
in the table (movelast) and I get an error message - invalid use of null.

Anybody have an idea what's going on?

Thanks,

Sarah
 
Do While (Not (MyTable.EOF))
If IsNull(MyTable!SeqNo) Then
MyTable.Edit
MyTable!SeqNo = k + 1
k = k + 1
MyTable.Update
Else
k = MyTable!SeqNo
End If
MyTable.MoveNext
Loop
MyTable.MoveLast
 
I figured it out. I did a delete query to the table I was adding new records
to before I added the new records and apparently the table was not getting
refreshed after the delete. So the code was looking at deleted records that
were not removed from the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record insert/delete anomaly 0
No current record 4
>> adodb.recordset last updated 3
VBA - retrieve data on last create named range from previous inserted named range 0
Add a new record to an access table 1
return primary key for record after append query 3
After Adding a New Record it remains the Last Record in Recordset 3
Err 3218, Could not update, currently locked Access 2007 Sharepo 1

Back
Top