Cascading Combo Boxes

[ldnguyen531]

I'm trying to do a cascading combo boxes for my forms and only one form is working. I was hoping to replicate the one working form to the rest but it doesn't seem to work. Could someone please kindly provide their contact so I can email the file directly? Thanks in advance for your support.

[Bob Fitz]

Why not zip your file and post it here

[ldnguyen531]

Why not zip your file and post it here

Oops, didn't see that feature. Thanks. I'm new to the forum. Please see the Connection Form. It works the way I want it to but using the same method for Inductor and Capacitor forms they only work to the second combo box which is "Subcategory". It stops working at "Type". Please help. Thanks.

[Bob Fitz]

Please explain how it

stops working at "Type"

[ldnguyen531]

Please explain how it

Hi Bob. When you select Inductor for Category then Coil or Transformer for Subcategory, I should get couple options under Type combo box. I don't see anything in my case. Please advise. Thanks.

[Bob Fitz]

When you select Inductor for Category then Coil or Transformer for Subcategory,

You can not select anything in the category combo box. The only selection made in the db is "Connection" which is actually selected by Access as the "Default Value".
Before concerning myself with this form I would suggest you look at some more basic things. You have twelve tables but only six have any relationship to another table? You are using look-ups in at least one of these tables (the one that your "non working" form is bound to for example) but I have seen them in others. Of perhaps less importance is using a consistent method for naming objects. You have used the "qry" prefix for your queries which is fine but you have used no prefix for table or form names so your forms all have the same name as a table.

[ldnguyen531]

You can not select anything in the category combo box. The only selection made in the db is "Connection" which is actually selected by Access as the "Default Value".
Before concerning myself with this form I would suggest you look at some more basic things. You have twelve tables but only six have any relationship to another table? You are using look-ups in at least one of these tables (the one that your "non working" form is bound to for example) but I have seen them in others. Of perhaps less importance is using a consistent method for naming objects. You have used the "qry" prefix for your queries which is fine but you have used no prefix for table or form names so your forms all have the same name as a table.

Hi Bob, I'm design the form separately. I purposely locked down the Connection form to "Connection". Please try the Inductor form. You can only select the Inductor for the Subcategory to show up. But then when you go to Type Coil or Transformer, you should have options but it's not coming up. I know I'm very close. Thanks.

[ldnguyen531]

Hi someone please download my file to see what's I'm doing wrong. Thanks in advance for your support.

[Missinglinq]

And before downloading note that it is in 2010 format.

[ldnguyen531]

Yes, thank you.

And before downloading note that it is in 2010 format.