When using a table type in my DAO I get No Current Record error when I try to AddNew and Update after a seek with Nomatch - any ideas?
Code is
If rsTable.NoMatch Then
rsTable.AddNew
etc.
Printable View
When using a table type in my DAO I get No Current Record error when I try to AddNew and Update after a seek with Nomatch - any ideas?
Code is
If rsTable.NoMatch Then
rsTable.AddNew
etc.
I think you should put a move method before the addnew:
If rsTable.NoMatch Then
rsTable.MoveLast
rsTable.AddNew
etc.