I have a listbox on a form that is filled with people's name, status, jurisdiction, etc. When a row is selected it will display the full person info on the form. What I am wondering is;
1) is it possible to use the selected row to filter the full list for the jurisdiction? In other words if the selected person's jurisdiction is Florida, can I filter the listbox for all other Florida people using the already selected person's jurisdiction?
2) if it is possible, how would I go about doing that?
I've tried using a SELECT statement with the WHERE clause using the column with the jurisdiction in it. No errors occur but the listbox will go blank. A msgbox to show the sql statement returns the statement but the WHERE clause is not showing anything for the jurisdiction.
Any thoughts on this?
Thanks...John