I am doing a coursework project that requires me to build a large amount of search forms. So instead of doing lots of small ones i thought if it was possible i could do one large one. This is how i envision it:
One form with criteria boxes. The first criteria box is a drop down box with all the possible tables the user can search. Then there are standard criteria boxes the user needs to fill in such as name and date. Then when a button is pressed, a subform according to the table selected is shown on the form with the records found from the name and date fields.
So basically i want to create lots of subforms which will display the found data for each table. I want the main form to display the subform which presents the data from the table selected in the criteria drop down box.
Is this in any way possible? I know it can probably be done if the subforms where opened in a new window, but can they be opened onto the main form (one at a time)?
One form with criteria boxes. The first criteria box is a drop down box with all the possible tables the user can search. Then there are standard criteria boxes the user needs to fill in such as name and date. Then when a button is pressed, a subform according to the table selected is shown on the form with the records found from the name and date fields.
So basically i want to create lots of subforms which will display the found data for each table. I want the main form to display the subform which presents the data from the table selected in the criteria drop down box.
Is this in any way possible? I know it can probably be done if the subforms where opened in a new window, but can they be opened onto the main form (one at a time)?