Adding more combo boxes to a form

[daveUK]

I have a database that allows users to store, categorize and view digital photographs. I'm creating a searchform to search the database by Category, Sub-Category or both. There are 3 combo boxes on the form which aren't visible to the user when the form is loaded and 3 checkboxes(Category, Sub-Category, Both). The user checks a checkbox and the relevant combo box is displayed. They then select a Category/Sub-Category/Both from the combo box, click a cmd button (which runs a query) and the relevant records are displayed. This is working OK. What I need to do is allow the user to click another cmd button, this will again give the user the choice of searching by Category/Sub-Category/Both and display another combo box. This will allow the user to search for 2 categories/sub-categories or a mixture of the 2 at once. I've been told that there is a way of adding combo boxes dynamically but I can't seem to find out anything about it.

I hope I've explained this clearly

Dave

 

[daveUK]

Thanks Pat,

I've managed to just about get it working by having lots of combo boxes on the form and setting their visible property to false until a command button is pressed.
It's probably not the best way to do it, but at least it works

[This message has been edited by daveUK (edited 03-17-2002).]