Populating a combo box based on a text box

[rrum]

I have been using an After Update VBA code that is supposed to work for cascading combo boxes, but I do not know if this is what I am supposed to be using for populating a combo box in a subform based on a text box in the main form, or if this is even possible. What I have in the main form is an unbound combo box with a filter command, which lists "clients" based on a client ID. Based on the client ID, the main form is populated by "category" records (several categories for each client). The Category ID is displayed within a text box. I have two subforms that relate to the category ID, which I would like to input records based on the category ID. Each subform has a combo box that I want to select records based on the categoryID of the textbox (I only want to display records from the lookup table that relate to the displayed category ID). Does this make sense? I used this code for the After Update of the text box: Me.cboREQuant.RowSource = "SELECT tblRiskExpQuant.REQuantID, tblRiskExpQuant.Risk_Exposure, tblRiskExpQuant.RiskCatID FROM tblRiskExpQuant WHERE tblRiskExpQuant.RiskCatID=" & Me.txtRiskCatID & " ORDER BY tblRiskExpQuant.Risk_Exposure" where cboREQuant is the combo box in the subform. The drop-down box in the combo box of the subform is just blank - it will not show any records, even though a query based on these components runs just fine.

[jzwp11]

Since the combo box is a control in the subform, you have to reference it differently if the code fires from the main form. The appropriate syntax is as follows:

Me.subformcontrolname.form!cboREQuant.RowSource = "SELECT..."

Check out this site for more on referencing controls and properities

[rrum]

Thank you!

[jzwp11]

You're welcome. Good luck with your project.