Flyoutbox on hover in Access?

[mrfixit1170]

Hello All again,



Is it possible to create a custom smart tag to be filled with data from another table. I have seen the microsoft smart tag sdk to create custom smart tags, but I don't think I can do that procedure. A good example of what I need is on this forms site if you hover over the thread title a flyout box pops up to show you more information. These are the tables I have that have the information I am dealing with for this issue:

Tasks 
Task_ID (Text)
Narrative(Text)  
Parent_ID(Text)

Site_Visits  
Task_ID (Text)
Maint_Funct (Text)
MOS_ID (Text)
Quantity(Number)
Time(Number)
DateTime(datetime)

On a form,form1 I have a listbox Listbox1 that sorts the Task_ID's and I have it setup for one selection at a time. Would I on a Got Focus event place a

Select Task_ID, Maint_Funct, MOS_ID, Time FROM Site_Visits   
 WHERE Task_ID = form!Listbox1 ""

Then have it display in a flyout box...how?

If there is no functionality in Access 2007, then thats cool too, it would be nice to see is all.

[June7]

You need something beyond what the ControlTipText property offers? Check out http://www.lebans.com/tooltip.htm

[mrfixit1170]

Thank you June7, this will work....