Multiple Filters and Combo Boxes Problems

TGHockett

Registered User.
Local time
Today, 04:24
Joined
Aug 16, 2000
Messages
65
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
 
Damn ... 24 hours and no reply??? Come on folks ... get creative
smile.gif


TGH
 
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.
 
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
smile.gif


TGH
 

Users who are viewing this thread

Back
Top Bottom