D
DGregg
I'm sure this is fairly easy but I'm not proficient enough in Access to
figure it out on my own. I want to create a form that uses multiple combo
boxes to set parameters (want to select multiple criteria within a combo box
as well, if possible); once all of the desired parameters have been set, I
want to be able to execute a query and get results based on the parameters
entered on the form. My original source data has fields that contain
multiple values (e.g. field name: Premise Type may contain up to two values
such as Duplex or Apartment), therefore I have created two separate fields
(Premise Type 1 & Premise Type 2) so that for those records containing two
values, one value will be placed in Premise Type 1 and the other will be
placed in Premise Type 2. The data that may reside in Premise Type 1 or
Premise Type 2 is the same (e.g. 'Apartment' may be in either Premise Type 1
or Premise Type 2). I don't know how to set up a combo box so that I can set
multiple criteria within one combo box (select duplex & apartment) that will
then query two different fields (Premise Type 1 & Premise Type 2) for either
of the parameters selected in the combo box. Thanks in advance!
figure it out on my own. I want to create a form that uses multiple combo
boxes to set parameters (want to select multiple criteria within a combo box
as well, if possible); once all of the desired parameters have been set, I
want to be able to execute a query and get results based on the parameters
entered on the form. My original source data has fields that contain
multiple values (e.g. field name: Premise Type may contain up to two values
such as Duplex or Apartment), therefore I have created two separate fields
(Premise Type 1 & Premise Type 2) so that for those records containing two
values, one value will be placed in Premise Type 1 and the other will be
placed in Premise Type 2. The data that may reside in Premise Type 1 or
Premise Type 2 is the same (e.g. 'Apartment' may be in either Premise Type 1
or Premise Type 2). I don't know how to set up a combo box so that I can set
multiple criteria within one combo box (select duplex & apartment) that will
then query two different fields (Premise Type 1 & Premise Type 2) for either
of the parameters selected in the combo box. Thanks in advance!