I am trying to write a code that will allow selection of a range of records from a table. The idea is that when the user selects EquipmentID #2 from the combo box control on the form, they will only be able to select from the size range associated with Equipment ID #2 from the Size combo box...
Dennisk - Here it is again using commas instead of spaces. I didn't realize that the text would all blend to gether when I sent this the first time.
Exactly! The idea is that when the user selects EquipmentID #2 from the combo box control on the form, they will only be able to select from the...
Exactly! The idea is that when the user selects EquipmentID #2 from the combo box control on the form, they will only be able to select from the size range associated with Equipment ID #2 from the Size combo box. Without knowing any other way to demonstrate this, I have added some information...
Hello Everyone!
I have a combo box on my form where I want to select a [Size] for a piece of equipment that has a particular ID. Here's what my query statement looks like:
SELECT tblMaintenance.Size, tblMaintenance.EquipmentID FROM tblMaintenance WHERE (((tblMaintenance.Size)=[Size]));
When...