none
Form to Search and Edit Records RRS feed

  • Question

  • I'm building my first database, and I have to say I'm not doing that bad. I've got a table, a form that allows users to upload excel files from a folder into that table, a form to select criteria and download data from the table and a form that simply displays some simple stats like number of records, etc. I put all this in a navigation form. 

    Now I want to create a form that allows users to call up a record from the table and make modifications. Maybe the Last_Name is misspelled. They can enter any one or combination of criteria and have fields from that record appear, and allow user modifications to be saved. It might be a good idea before I begin to pose this probably mundane chore to the group of experts for advice. Maybe there's already a resource, tool or other to jump start this part of my project.

    Any advice welcome.

    Tuesday, December 1, 2015 11:19 PM

Answers

  • Hi todtown,

    Based on your description, it seems you want to filter form record, and edit the records, if so, I think you could refer the code below:

    Private Sub FilterRecord_Click()
    'filter
    Me.FilterOn = True
    Me.Filter = "id=3"
    'edit record
    Me.Controls!Field1 = 20
    End Sub

    #Form.Filter Property (Access)
    https://msdn.microsoft.com/EN-US/library/office/ff194672.aspx

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Thursday, December 3, 2015 1:39 AM

All replies

  • Hi. If you're looking for ideas or samples of "search forms," I suggest taking a look here. Good luck!
    • Marked as answer by todtown Wednesday, December 2, 2015 1:10 AM
    • Unmarked as answer by todtown Wednesday, December 2, 2015 5:33 AM
    Tuesday, December 1, 2015 11:24 PM
  • Yikes! This list should keep me busy for awhile. Thanx. 
    Wednesday, December 2, 2015 1:10 AM
  • Hi. There's lots of good examples there for almost anything you need. Just holler if you need further assistance. Happy hunting.
    Wednesday, December 2, 2015 2:21 AM
  • Hi todtown,

    Based on your description, it seems you want to filter form record, and edit the records, if so, I think you could refer the code below:

    Private Sub FilterRecord_Click()
    'filter
    Me.FilterOn = True
    Me.Filter = "id=3"
    'edit record
    Me.Controls!Field1 = 20
    End Sub

    #Form.Filter Property (Access)
    https://msdn.microsoft.com/EN-US/library/office/ff194672.aspx

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Thursday, December 3, 2015 1:39 AM