Results 1 to 4 of 4
  1. #1
    tylerg11 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    200

    Delete continuous form record

    I have a button in my continuous form that shows up next to each record. I want this button to delete the record next to it with the Recordset.Delete code. Sometimes it works, and other times it says a current record is not selected. What can I added to the code to make sure that it selects the record it is next to? Thanks.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    You allow records to be deleted? What situation occurs that this is a reasonable act?

    Show the code. Do you requery the form after delete action?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    tylerg11 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    200
    Currently I'm just using Recordset.Delete and it has been working.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    But you say not always? I haven't used that code. Do you want to provide project for analysis?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. VBA delete current record continuous form
    By tylerg11 in forum Forms
    Replies: 3
    Last Post: 02-17-2012, 12:57 PM
  2. Hiding a new record in a continuous form
    By system243trd in forum Forms
    Replies: 3
    Last Post: 12-03-2011, 01:04 AM
  3. Replies: 1
    Last Post: 11-21-2011, 07:52 PM
  4. Replies: 13
    Last Post: 11-08-2011, 11:57 AM
  5. Get position of record in continuous form
    By Whizbang in forum Forms
    Replies: 3
    Last Post: 11-02-2011, 01:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums