Multiple Value ListBoxes and Hyperlinks

[GendoPose]

Hi all,

I have a list box on my form with different users selected. I want to be able to double click on one of the values in the list box and open a form to a specific record. I can do the DoCmd.OpenForm part, but I'm not sure how I would put this on each value in the listbox.

Also, ideally I would like to exclude the unchecked values in the list box if possible, without changing the query.

Any ideas?

Thanks

 

[jdraw]

You have asked several questions, but unfortunately you haven't provided much info for the reader.

Can you post a jpg of your tables and relationships?
And/or a screen capture of your Form?
Or a few lines to help put some meat on your initial post?

Are you familiar with OpenArgs of a Form?

http://www.datawright.com.au/access_resources/access_docmd.openform_arguments.htm

 

[GendoPose]

You have asked several questions, but unfortunately you haven't provided much info for the reader.

Can you post a jpg of your tables and relationships?
And/or a screen capture of your Form?
Or a few lines to help put some meat on your initial post?

Are you familiar with OpenArgs of a Form?

http://www.datawright.com.au/access_resources/access_docmd.openform_arguments.htm

Here are the screenshots.

I don't know what else I can say, my form is linked to a query which shows the Name, Genre, CurrentMembers and PreviousMembers. Current and PreviousMembers are multiple listboxes, and I just want it to filter out the unchecked values, i.e if John Doe is checked for a current member and Jane Doe isn't, then I only want the list box to show John.

Also I can't say I am but I've had a flick through it and I can't really see where to even begin let alone implement it.