View Full Version : Multiple Filters and Combo Boxes Problems


TGHockett
12-11-2000, 08:58 PM
As usual probably a simple answer awaits, but what I want to do is allow the user (when the 'edit proposal' form is called up), I want to give them the option of either:
1): Entering the proposal ID (a primary key)
2): Seclecting from the entire list of proposals to edit (approx. 500 records)
3): Or from an option group or such, select a list box for a channel sub-group/filtered list of the submitted /proposals (e.g., Region 1,2,3,National program proposals, etc.)

By using the combo box wizard I am easily able to accomplish objective #s 1 & 2 above ... but can't figure out how to add list boxes in an option group for the channel filters. I am thinking now A2k does not allow list or comboboxes within an option group... so was thinking of using the Tab Controls alternative (each tab with a different query as its control/row source property), but my early experiments in that direction clearly showed I am barking up the wrong tree.

Any thoughts or ideas? Or links to MDSN site articles?

TGH

TGHockett
12-12-2000, 08:11 PM
Damn ... 24 hours and no reply??? Come on folks ... get creative http://www.access-programmers.co.uk/ubb/smile.gif

TGH

Ernie Taylor
12-14-2000, 05:55 AM
I would suggest that you keep it simple. Jump to a new form on the third selection (by including an open form button)and run a query based on that using a subform.

TGHockett
12-14-2000, 07:12 PM
Hi Ernie ... Pat H. and others keep telling me to K.I.S.S. and I think you are right suggesting I go against my overcomplicating nature ... thanks for the idea http://www.access-programmers.co.uk/ubb/smile.gif

TGH