description lookup via mouse pass-over or mouse click

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a form with many "codes" that have their related descriptions stored
in their source table. To save space on the form and that the fact that many
users know most of the codes, I'd like the ability to pass the mouse pointer
over the field or click any of these "code" fields and the description would
diaplay to the user much like "ControlTipText" or in a "MsgBox". The former
would be easier as it's more passive and does not require the follow-up OK
click of the message box. Please share your thoughts and experiences.

I Thank You,
John_Lehmus
Maine, USA
 
John_Lehmus said:
I have a form with many "codes" that have their related descriptions stored
in their source table. To save space on the form and that the fact that many
users know most of the codes, I'd like the ability to pass the mouse pointer
over the field or click any of these "code" fields and the description would
diaplay to the user much like "ControlTipText" or in a "MsgBox". The former
would be easier as it's more passive and does not require the follow-up OK
click of the message box.
Click to expand...


Personally, I don't like those popup info thinies because
they obscure other info on the form. OTOH, they may be
handy in your situation. Anyway, you can do that by using
code in the form's Current event to populate each control's
ControlTip property.

Me.txt1.ControlTip=DLookup("Descr","Descriptions", _
"code=" & txt1)
Me.txt2.ControlTip=DLookup("Descr","Descriptions", _
"code=" & txt2)
.. . .
 
Back
Top