How to identify which record in a continuous form was clicked on?

[ElRudi]

Hey all,

I have a continuous form with an image and a text box on it. When the image is clicked, some text should appear in a text box. The problem is that the text appears in the text box of the incorrect record.

Suppose the first record is the 'current' record (i.e., having the record selector to its left), and the user clicks on the image in the third record. Then the text appears in the first record, not the third.

Is there a way to find out which of the records was clicked on? Or, can I change the current record to be the one whose image was clicked on?



Thank you in advance!

[June7]

Clicking on the image is not selecting the record? This image is an ImageControl with a ControlSource? The textbox is bound? Do you want to provide project for analysis?

[ElRudi]

Hey June7,

Thanks for your quick reply!

The form has a query bound to it, and the textbox is bound to one of its fields. The image's control source is something like '=IIF([PicA]=TRUE, "C:\picA.png", "C:\picB.png"), with an OnClick-event that writes to the textbox.

Clicking on the image does not select the record.

Let me know if you want me to provide a stipped version of the project for analysis!

Ruud

[June7]

Yes, think I need to work with the project to analyse.

[ElRudi]

Alright,

It was not so easy to reduce all below the 500kb limit but i managed

Copy the 2 png files to the C:\ drive if you can, or change the image's control source to whereever you put them. Somehow they are shown much smaller than their original sizes - no idea why. But the main problem now is the one i described - clicking on one image fires the OnClick event in the current record, which is not necessarily the one that was clicked.

Thanks!

[June7]

Zip files have a 2mb limit.

The images are not downloading. That form does not have image controls. Just a single textbox with control source of SmsText

[ElRudi]

Hmmm.... to the left of the text box there should be an image control, with an OnClick-event coded in VBA... I'll zip it all up and add it to this post, including a screenshot of what it looks like on my PC.

I'm off to bed now, so take your time

Thanks again

[June7]

Guess the image control was there, just didn't recognize it because image so small. I set the SizeMode property to Zoom and the image enlarged.

Annoying, clicking on the image control will not select the record. Something MS needs to work on?

The code does run but odd thing is it doesn't stop on a breakpoint. Breakpoint didn't work in any procedure I wrote. Weird.

I changed the Requery to Refresh so it stays on the record I selected by clicking in textbox.

Only thing I can suggest is to put next to the image control a Toggle button bound to the IsSpecial field then Me.Refresh code in its click event. The Image click event would not be needed.

[ElRudi]

[ElRudi]

Alright, no problem - thanks for tbe effort!

i guess i'll have to figure out some workaround - maybe a transparent non-bound textbox on top of the image which catches the click event...

Or maybe someone else has a solution?

Thanks again!

R

[June7]

I tried that. When you click in a textbox, even if set as transparent, it becomes opaque until you leave it. I also tried a rectangle graphic. A bound toggle button (or a checkbox, but can't size them) the only workaround I can see.

[ElRudi]

Ah i see... maybe I can put focus on another cqntrol as soon as the text box is clicked, though that might cause a small 'glitch'/flash of the text box appearing/disappearing whenever the user clicks it.

I'll play around with it a bit and let you know how I solved it.

[June7]

Thought about the checkbox again. Can't size the checkbox itself but can size the check area. Don't actually have to click right on the little checkbox itself. Can click anywhere inside the control frame or on a label associated with the checkbox. So you can size its label to frame the star image but size the checkbox frame so small the checkbox can't be seen. When click the label, a dotted outline will display but the checkbox doesn't show. Don't put any caption on the label. Actually, clicking label associated with button control will also execute the click event, but don't get a dotted outline.

Will this be acceptable compromise?

[ElRudi]

Yes, that will be acceptable, and works just fine - thanks!

I noticed an image control cannot be given focus; i guess this is why clicking one does not make it the current record.

Thanks again for your help!