Results 1 to 2 of 2

Thread: Tables using DAO

  1. May 20th, 2000, 09:51 PM #1
    Caro
    Caro is offline

    Thread Starter
    Addicted Member
    Join Date
    May 1999
    Location
    Littlehampton, W Sussex GB
    Posts
    203
    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.

    Reply With Quote Reply With Quote
  2. May 21st, 2000, 01:43 PM #2
    pardede
    pardede is offline
    Addicted Member pardede's Avatar
    Join Date
    Jan 2000
    Posts
    232
    I think you should put a move method before the addnew:

    If rsTable.NoMatch Then
    rsTable.MoveLast
    rsTable.AddNew
    etc.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width