J
Jay
I have a form with 3 cascading combo boxes; combo box 3's list is
dependant on the selection from combo box 2's list which is dependent on
the selection from combo box 1.
However because of the number of records in each box I would prefer to
use list boxes. I've tried to just do exactly the same as my combo
boxed form but using list boxes, but can't get it to work.
For example, my row source for the second list box is:
SELECT DISTINCTROW tblDerivatives.Model FROM tblDerivatives WHERE
(((tblDerivatives.Manufacturer) Like
forms!frmMovementRationaleLists!lstManufacturer));
where lstManufacturer is the first list box.
List box lstManufacturer works OK but I get a 'Enter Parameter Value'
prompt detailing 'forms!frmMovementRationaleLists!lstManufacturer'
AM I trying to do something that you can't do this with list boxes like
you can with combo boxes.
If so, can anyone advise me what I'm doing wrong.
Many thanks,
Jason
dependant on the selection from combo box 2's list which is dependent on
the selection from combo box 1.
However because of the number of records in each box I would prefer to
use list boxes. I've tried to just do exactly the same as my combo
boxed form but using list boxes, but can't get it to work.
For example, my row source for the second list box is:
SELECT DISTINCTROW tblDerivatives.Model FROM tblDerivatives WHERE
(((tblDerivatives.Manufacturer) Like
forms!frmMovementRationaleLists!lstManufacturer));
where lstManufacturer is the first list box.
List box lstManufacturer works OK but I get a 'Enter Parameter Value'
prompt detailing 'forms!frmMovementRationaleLists!lstManufacturer'
AM I trying to do something that you can't do this with list boxes like
you can with combo boxes.
If so, can anyone advise me what I'm doing wrong.
Many thanks,
Jason