Tree View - Working with mouse over and list control

[Parker]

Can't find a lot of info on this

I have an example from MS but I can't work out what goes on.

I have a tree view control listing items from a table. What I want is when someone moves the mouse over an item it displays additional information stored in the same table and some information from linked tables.

I also want a user to be able to click an item in the tree view and bring up a list control with information from a linked table and then be able to click items in this list to display other information.

I am using Microsoft TreeView control v6 ;List View and Access 2002 In XP Pro.

The tables involved are:

tblRecording

RecordingID(PK)
RecordingTitle
YearReleased
PurchaseCost
DateOfPurchase
CurVal
Condition(FK)
MusicCat(FK)
TrackList(FK)
RecordLab(FK)
Format(FK)
LibraryID
Artist(FK)
TrackNumber​

tblTrackList

TrackID(PK)
TrackTitle
Length
Artist(FK)​

tblRecordingArtist

RecArtID(PK)
RecArtName​

tblRecordLab

RecLabID(ID)
RecLabName​

tblFormat

FormatID(PK)
Format​

There are other fields in all tables but, for this exercise, they are irrelevant I think.

What I want is when a user hovers the mouse over a record title in tree view, it will display Artist, Format, RecLabName and LibraryID;
When a user clicks (double click may be better) then List View will display a track list. If a track name is clicked then I want it to display information about the individual track. (Artist name track position,length,etc.)

Can anyone help with this?

Cheers

 

[Parker]

Bump

This was posted on sunday so it Prob. got missed.

I would really apreciate some help with this. I just cannot get my head around what goes on.

Cheers

 

[danikuper]

Hi,

Have you fixed your problem? I'm working on a treeview control that seems similar to what you want. In my treeview when a user clicks an item, I can open another form (or anything for that matter) with info related to that item.

Let me know.