maxmangion
AWF VIP
- Local time
- Today, 16:20
- Joined
- Feb 26, 2003
- Messages
- 2,805
Hi,
I am creating a search form which is going to have about 4 combo boxes, which will be populated from lookup tables. The "enabled" default value of these combos are going to be set to false, and at any one time, only 1 combo box can be enabled. This form will return records from a query so in the query design view under a field called series i am placing the following criteria [Forms]![frmSearch]![cboSearchSeries] then on another field but in the "Or" critieria (i.e. not in the same line with the series criteria), i am putting [Forms]![frmSearch]![cboSearchFormat] and so on.
Now since i have about 4 combos (and considering that only one value from one combo can be passed at any one time), is this a correct approach in this scenario, or is there a better way of doing this ?
Thank you
I am creating a search form which is going to have about 4 combo boxes, which will be populated from lookup tables. The "enabled" default value of these combos are going to be set to false, and at any one time, only 1 combo box can be enabled. This form will return records from a query so in the query design view under a field called series i am placing the following criteria [Forms]![frmSearch]![cboSearchSeries] then on another field but in the "Or" critieria (i.e. not in the same line with the series criteria), i am putting [Forms]![frmSearch]![cboSearchFormat] and so on.
Now since i have about 4 combos (and considering that only one value from one combo can be passed at any one time), is this a correct approach in this scenario, or is there a better way of doing this ?
Thank you