Form to Search and Edit Records

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.

Answer 1

Hi. If you're looking for ideas or samples of "search forms," I suggest taking a look here. Good luck!

Answer 2

Yikes! This list should keep me busy for awhile. Thanx. 

Answer 3

Hi. There's lots of good examples there for almost anything you need. Just holler if you need further assistance. Happy hunting.

Answer 4

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.