I have a form with a sub form. I would like to add a list box or combo box that will pull up all the data in a field in the main table field TOPIC. Then scroll through the list of TOPIC entries and click on one. When Clicking on the item in the list or combo box it will take me to that record. I know I can scroll through them in the navigation bar but that takes a long time to get to the item I want.
how do I dot this?
Best regards
Joel
You need a separate form which saves the value of the listbox.
Example:
tbl_filter with field ID (Boolean) and “Topic” AS Varchar.
First and only value for ID will be TRUE.
Form should only save one value, so no navigation, only changing the value is needed.
Mainform will depend on a query:
SELECT * FROM "tbl_mytable"
WHERE "Topic" = COALESCE((SELECT "Topic" FROM "tbl_filter" WHERE "ID" = TRUE), "Topic")
This query will show all values of “tbl_mytable” if no “Topic” has been choosen.
You have to choose a value in the listbox and press a button, which should reload the mainform.