MS Access: Edit Button

Hi,
I am new at Access and I am creating an intake system for work.  I have a "browse all intake" datasheet where all the data entered into the intake will be displayed.  I would like to add an "edit" button into the datasheet so that the users can edit the data where needed.  Can someone please help me with this?  Thank you for your time.

sarah_siuAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
sarah_siu,

How many form do you have to do this?
I count 3 so far?

"When I select the record selector button, only the fields in my "browse_all_intake" shows up as a form."
Didn't you know what fields the  "browse_all_intake" form would display?

Basically you need to examine the code I put on each form.
Then apply the same code to the forms you want to use.

Try this on your own first, then post back if you have any issues.

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
sarah_siu,

1. All "Editing" should take place in a from, not the table.

2. Furthermore, you cannot put buttons on a anything in "Datasheet View" anyway.

3. Lastly, (Unless explictly disable it) the form should be in "Edit" mode by default.
So I don't see the need for an "Edit" button.

Can you please clarify what you are trying to accomplish with this system?

JeffCoachman

JeffCoachman
0
 
sarah_siuAuthor Commented:
I have a Browse_All_Intake form in the datasheet view right now which can be accessed by pressing a button on a form.  I would like to add an "edit" link to this datasheet (in the first column) so that when i go into this "edit" link, the form pertaining to the line of data will pop up and then the user can edit whatever they want on the form and save it back to the table.  So, not so much an edit button as oppose to an "edit" link in the first column. How do I tie the edit links for each line of data to its the correct form?  
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jeffrey CoachmanMIS LiasonCommented:
Try this:

Click the record Selector button (The button/box immediately to the left of the record), to jump to the "Edit" Form.

JeffCoachman
Access-EEQ23883437OpenRelatedRec.mdb
0
 
Jeffrey CoachmanMIS LiasonCommented:
Try this:

Click the record Selector button (The button/box immediately to the left of the record), to jump to the "Edit" Form.

JeffCoachman
Access-EEQ23883437OpenRelatedRec.mdb
0
 
sarah_siuAuthor Commented:
I see what you mean.  When I select the record selector button, only the fields in my "browse_all_intake" shows up as a form.  

What I would like is to have the actual form (the form that the user had originally filled in with all fields in the database table) to pop up instead.  I know I have to create an edit link so that it links to the form but i'm not sure how to go about it.  Do I need to create a macro and then input it in the "on-click" section in the properties?
0
 
sarah_siuAuthor Commented:
Excellent job.
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.