View Full Version : How do I use a new form to search records in a table


Antony
03-11-2001, 03:25 PM
I want to open a "find records" form from the switchboard, It will select criteria from a combo box and then show the results in a report...Will access let me do this and How. New form = "search". Look up from "Section" combo box in "lost property" table. Print results in "found" report.

Anauz
03-12-2001, 02:08 AM
yes you can do this. Have a form for search criteria. Have a second form which runs a query based on the search criteria ([forms]!["form_name"]!["combo_box_name"])
on the second form have a button to a report which is based on the data of the second form.