list form filtering from 1 combo box

[cooper]

Hi guys,

I have few tables:

tblEmployees:
titleID - primary key
titleNme - (grouped into different categories like slotters, analysts, etc)

tblType:
TypeID - primary key
TypeName - (types would like general information, Standard operating procedures etc)

tblReports:

ReportID - primary key
titleID- foreign key to tblEmployees
typeID - foreign key to tblType
NmeReport
Location (Hyperlink)


What I want to do is let the user select their category (slotters, etc) from a combo box, and then this displays a list box where reports name, type and location is shown - Clicking the location should open the hyperlinked document.



any ideas? thanks guys!!!

[June7]

What have you attempted and what is the issue?

You want the listbox choices to be limited by the choice made in combobox? That is cascading or dependent combo/list boxes. Check this tutorial http://www.datapigtechnologies.com/f...combobox2.html

Set the listbox as disabled or not visible then in the AfterUpdate event of combobox, make the listbox available and requery it.

[cooper]

hey June7! thank your for your help again.

the combo/list box is working perfectly now. One thing though:

one of the fields in my list boxes is a hyperlink - How do I make it clickable?

the hyperlink works fine in a table. I have made the data field for this column as "Hyperlink"

thanks!

[June7]

Bind a textbox to hyperlink field or run the hyperlink in VBA code. Check these articles
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx
http://allenbrowne.com/func-GoHyperlink.html

[cooper]

How do I call a function in a list box? I added the module on the database.

Hyperlink field in my table is called Location - where different hyperlink is given. List box shows these different hyperlinks.. how do I connect all this now?

thanks again!!!

[June7]

A listbox RowSource can be an SQL query statement. Use the query builder (click the ellipses ...) to open the designer. Refer to a custom function just as you would any intrinsic function. The custom function must be behind the same form that has the listbox or else a Public function in a general code module.

I could not get hyperlink to work from listbox.