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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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?  
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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
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?
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sarah_siuAuthor Commented:
Excellent job.
Jeffrey CoachmanMIS LiasonCommented:
;-)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.