MasterPartList.zip
You can do what you want with your current structure, but you have to be a lot more capable in your programming.
What you want is something like
Code:
tblPartType
PT_ID PT_Name
1 Blower
2 Capacitor
tblModel
M_ID M_Name
1 Model1
2 Model 2
tblModelPartSerial
MPS_ID M_ID PT_ID MPS_Number
1 1 2 SG400Blower#
2 1 1 SG400Cap#
3 2 2 SG600Blower#
4 2 1 SG600Cap#
Which is a 'normalized' data structure mentioned in several prior posts on this page.
Then you can simply use cascading combo boxes and apply a criteria to get what you're looking for.
All that being said, I'm enclosing a copy of your database showing you how to do it with your current structure. It's pretty dirty but it works. You'll have to do some cleanup if you want to exclude the model number from the list selecting the part.