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:
Code:
Tasks
Task_ID (Text)
Narrative(Text)
Parent_ID(Text)
Code:
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
Code:
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.