1) Combo box option depending on previous combo box value & 2) subform depending on c

[oakridge1]

1) Combo box option depending on previous combo box value & 2) subform depending on c

1) Combo box option depending on previous combo box value & 2) subform depending on combobox input value problem

I am having these 2 problems and I have been googling for the past few days but canot solve the issue still.

1) Combo box option depending on previous combo box value

What I am trying to do is to narrow the 2nd combo box choices to the 1st combo box selection. Eg: 1st combo box is a list of countries, 2nd combo box is a list of cities in the countries. User select USA in 1st combo box, than 2nd combo box is list of US states like LA, New York etc etc.

1st Combo box : (ComboMainParts) Main Parts List (Aka Engine, Windscreen)
1st Data table: MainParts
2nd Combo box: (ComboMainPartsD) Models of the Main parts List (Aka Engine Model, windscreen model)
2nd Data table: MainPartsDetails

I tried using the Query method to filter it based on the Combobox selection, but the 2nd combo box does not show any results.
1) I did a after update code to change combo box 2 values when combo box 1 value changes

Private Sub ComboMainPartsD_AfterUpdate()
ComboMainParts.Requery
End Sub

2) Added a Row Source code to reference the MainPartsDetails Table and set the criteria filter

Row Source: MainPartsDetailsQuery

Criteria: [Forms]![MainPartsDetails]![ComboMainParts]

2) subform depending on combobox input value problem

I am trying to preview the information of the Main Parts Details in the same form. So when I choose the Main parts Engine >>> Engine Model : Rolls Royce Trent . I want to load the details related to that engine model like fuel used, fan blades used etc etc. That data is in the 3rd table name Engine Model details.

I tried using the Master and child data link but it cannot load the subform after I have selected the combo box option.

Any help appreciated

 

[bob fitz]

Re: 1) Combo box option depending on previous combo box value & 2) subform depending

Can you post a copy of your DB

 

[CJ_London]

Re: 1) Combo box option depending on previous combo box value & 2) subform depending

looks like your logic is wrong.

2nd Combo box: (ComboMainPartsD)
Private Sub ComboMainPartsD_AfterUpdate()

From what you have provided it looks like you are requerying the first combo in the after update event of the second combo

It should be requery the second combo in the after update event of the first combo

 

[oakridge1]

Re: 1) Combo box option depending on previous combo box value & 2) subform depending

Uploaded my DB

drive.google.com/open?id=0B4ki-s9qqSLdTmoxbEhXbkhOWXc

I did the requery from after update of first combo but still cannot work:banghead::banghead: