on mouse move

[jcridgeway]

I have a theatre seating chart that shows each seat as a separate label. I plan to set the color of the label depending if it is "not taken", or if a student/senior/adult has taken the seat.
I HAD planned on having two forms - 1 displaying the seating chart and another that displays the persons information if the seat is "taken".
Is there a way to have the info on the personal data form update as the mouse moves across the seating chart? Right now I have the "on mouse move" event trigger a macro that opens the personal data form, but I cannot get the focus to go back to the seating chart.
I am only interested in having the info be displayed. If the user wants to modify the data, they have to double click the seat.
Thank you
- jc -

 

[Peter D]

This sounds like a job for the ControlTipText property.

I'm not sure I have all the details of your form down, but you can write some code to update each control's ControlTipText with the pertinent data for that control.

Also, if I recall correctly what this tool does, it might help: http://www.lebans.com/tooltip.htm

Hope this helps,

 

[ChrisO]

Yes it can be done but may get a bit complicated in code.

If we assume we have a booking table, with the appropriate booking information, then the Booking ID could be placed in the label’s Tag property. As the mouse moves over a label the information about the booking can be displayed using the booking ID.

The information could be displayed in text boxes in the form header.

You would only need one mouse move event for all labels and you will need some way to store the booking ID in the Tag properties on form open.

The theatre seating chart would be limited to about 700 seats because of the limit of the number of controls on a form.

Sounds like a lot of work but could be very useful if done well.

Regards,
Chris.