Select Range of Records from a Table

[mroberts653]

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. Without knowing any other way to demonstrate this, I have added some information about the tables and the way I have set them up.

tblEquipmentList contains the following records:
EquipmentID;EquipCode;Description (examples below)
1, PKGU, Packaged Unit Heat/Cool Air Cooled
2, PKGU, Packaged Unit Heat/Cool Water Cooled
3, PKGU, Packaged Gas Driven Unit Heat/Cool
4, FURN, Split System Cool Only Air Cooled
5, HPMP, Heat Pump Packaged Air Cooled

tblMaintenance contains the following records:
MaintenanceID;EquipmentID;Size (examples below)
1, 1, 2 tons
2, 1, 3 tons
3 to 24, 1, 4 tons, etc thru 200 tons
25, 2, 2 tons
26, 2, 3 tons
27 to 48, 2, 4 tons, etc thru 200 tons
49, 3, 2 tons
50, 3, 3 tons
51 to 72, 3, 4 tons, etc thru 200 tons

tblEstimateEquipment contains the following records:
EstimateEquipmentID;MaintenanceID;EquipmentID;EstimateID (see examples)
4, 8, 1, 5
5, 480, 25, 6
8, 4, 12, 5
10, 679, 34, 7
11, 8, 1, 8
12, 173, 8, 5
7, 8, 1, 11

I hope this explains what I'm trying to do. I'm really confused on this. Any help is appreciated.

 

[boblarson]

Do a search here on Cascading Combos. Also, don't post the same question twice. You posted it twice 14 minutes apart. You can delete your other post if the post title didn't suit you. To do so go to your post, click EDIT and then a delete button will become available.

I've already deleted it now, but in the future remember that.