Move to Current Record

[Novice1]

I have a form with (continuous forms). In each record there is an icon which sends an e-mail to the e-mail address in the record.

The process works fine if I'm in the record then click the icon.

If I open the form and see 10 records, I want to be able to click the icon, on any record, to send the e-mail to the person in that record.

When I open the form, my cursor is on the first record, if I click the icon in the fifth record, the event procedure is applied to the first record (not the fifth record).

I don't know how to redirect from record 1 to record 5 (or any other record), without actually clicking on the fifth record before running the event procedure.

I thought if I saved the record first (DoCmd.RunCommand acCmdSaveRecord) that I would be redirected to that record. I was wrong.

How do I move to the record I'm working on, without having to click in one of the fields of that record?

 

[pbaldy]

Is the icon just a picture? A button should work as you wish, I've never tried with an image.

 

[missinglinq]

Clicking on a Command Button, on a given Record, sends the Focus to that Record...but clicking on an Image does not...who knew?

A workaround would be to use a Command Button and add an Image to the button. With Button selected, go to Properties - Format -Image.

Linq ;0)>

 

[CJ_London]

I think it is because an image control doesn't receive the focus (it does not have got focus and lost focus events), whereas a button does.

Agree the workaround using an image on a button is the way to go