Results 1 to 2 of 2
  1. #1
    newstudent is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2017
    Posts
    1

    Search, edit and delete in access

    Hi everyone,
    I am attempting to build a database in access utilising forms. Adding data is fine but in order to edit and delete an existing record, one must search first. I am trying to get the search function operating and the results of the search to appear on a separate form with an edit and delete button allowing those functions to be done on that very record. Tutorials only show split forms where the results of the search(typed or combo box) appear on the same form and I'm finding difficulty linking an edit an delete button to that record.


    Hope that was clearly explained, I tried and I'm extremely new to access.


    Click image for larger version. 

Name:	Screenshot (4).png 
Views:	12 
Size:	154.9 KB 
ID:	29327Click image for larger version. 

Name:	Screenshot (5).png 
Views:	12 
Size:	158.9 KB 
ID:	29328This is just an example I followed where the search bar and results are on the same form along with the code.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Should not really need to programmatically set RecordSource.

    Review http://www.allenbrowne.com/ser-62.html

    The constructed criteria string can be used to open a form or a report.
    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. Search, Add, and Edit Forms - Need Help!
    By kwarden13 in forum Forms
    Replies: 8
    Last Post: 03-13-2016, 12:22 PM
  2. Access Design and Form - Search, Add, Edit
    By kwarden13 in forum Database Design
    Replies: 16
    Last Post: 02-29-2016, 08:39 AM
  3. Replies: 7
    Last Post: 12-04-2015, 10:50 AM
  4. Prevent edit or delete data or records from a table
    By mosquito_admin in forum Security
    Replies: 1
    Last Post: 03-01-2012, 06:02 PM
  5. Prevent edit and delete after printing a form
    By damie in forum Database Design
    Replies: 10
    Last Post: 01-11-2011, 06:47 AM

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