Clicking a image column in the forms grid does not change the CurrentRow value

I want to allow the users to click on the trash can image and delete the row. The problem is  clicking the image does not change the forms "CurrentRow" value, they must first click in another column to adjust the current row then click the image. How can I have clicking the image adjust the "CurrentRow".

Forms RecordsetType is SnapShot

Bob HoffmanDeveloperAsked:
Who is Participating?
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.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
That doesn't really look like an Access datasheet listing. Is that some sort of 3rd party control?
Bob HoffmanDeveloperAuthor Commented:
no, it's access.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Can you provide a sample database? It's going to be difficult to help without one.
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.

Bob HoffmanDeveloperAuthor Commented:
Here you go. I think the issue is that an image can't be given focus so the currentRecord wont change. If you click the checkbox next to the image the currentRecord changes but the checkBox click event doesn't fire?

I'm not opposed to doing this differently if there's a better way, I just need the recordset type to be snapshot and have something the user clicks on to fire an event where I can verify the delete and delete the row.

Bob HoffmanDeveloperAuthor Commented:
Seems a control that can't receive focus will not change the forms current record when you click on it. So I needed to use a control other then an image.

Went with the following hack.... I mean work around:

changed the delete image to a textbox, made the textbox look like a checkbok. The Checkbox onClick event didn't fire when I set the recordset type to snapshot so I couldn't use a checkBox.
in the onClick event on the textbox I processed the delete, in the event that the delete was denied I showed the error and set focus to the next control in the grid (so the user couldn't type in the box)

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
Bob HoffmanDeveloperAuthor Commented:
Solved the problem myself.
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.

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.