Bound Cascading Combo Boxes in continous forms

[workingpoor]

My goal is to have two combo boxes the first filters the second. it controls the semester that I am viewing. This works if i don't use continous forms but when i do it requeries every record in the form instead of the current record. I am not an access or vb guy but i have picked a lot up. please help!!!


I have attached a copy of my database.

 

[patrickglass]

i hate to take over this thread but i am looking for the exact same solution.
Currently i am using Me.cboAssemblies.Requery on the onUpdate from cboEquipment

the linking works fine but as soon as i change one of the equipment combo boxes all the other cboAssemblies go blank

I was just wondering (asking also on behalf of this thread starter) how you can specifically specify the combo box instance. Thanks for the time. We are both thankfull for you response

 

[workingpoor]

Im not really sure what you are asking... can you clarify it a little

 

[patrickglass]

well sorry i wasn't asking a question really. i have however found a rough solution that may work for you


Private Sub cboMakeList_AfterUpdate()
Me.cboModelID.RowSource = "SELECT tblModels.ModelID, tblModels.Model FROM tblModels WHERE (((tblModels.MakeID)= [Forms]![frmOrders]![frmOrderDetails]![MakeID]));"
Me.cboModelID.SetFocus
Me.cboModelID.Dropdown
End Sub

this is not my code and was shown in many other threads like http://www.access-programmers.co.uk...62&highlight=Cascading+combos+continuous+form

this works for me but the user has to select the first combo box and then the second if they want to have it repopulated eg. if you are already on the 5th entry on the sub continuous form and want to change the second value of the second combo box the box would still be showing the values of the last rowsource which may or may not be the same as what you want. i hope i am not too confusing for you.

But i am still looking for a better solution to the cascading combo boxed on a continuous form. Patrick

 

[WrHn85]

If it's any use, I have come across 2 solutions to this.

One is a really interesting workaround by Pat Hartman, where he sets a bound textbox over the cbo (leaving the drop arrow visible) and so it displays the value of the cbo. (FixCascadingCombosWithLabel)

The only actual solution of the problem I have found is on Rogers Access Library and he shows the before & after versions for you.(CascadingComboInSubform2k)