Synchronized Combo boxes again 1

[rowan1]

I have a form order details with three combo boxes; cbocategoryselect, cboproductselect and cboitemselect. I want to synchronize these so that product is dependant on the choice of category and item is dependant on the choice of product. The code I have is

Private Sub cbocategoryselect_AfterUpdate()
Me.cboproductselect.Requery
Me.cboproductselect.SetFocus
End Sub

Private Sub cboProductSelect_AfterUpdate()
Me.cboItemselect.Requery
Me.cboItemselect.SetFocus
End Sub

This seems to work standing alone but when I try to put it as a sub form inside an order form. I keep getting asked for the parameter value of each combo box. Can anyone help please?

 

[nrugado]

I have gotten this error before and I have found that it happens when I close the form. The fix that I stumbled upon was instead of closing the form run a macro that minimizes the form first and then closes it. Somehow this prevents the qry's from running and the form closes smoothly. I hope this helps.

 

[Beeps]

You have to specify/reference the forms in order to do this, that is why you're getting error messages

So if you had a Mainform and a subform where a combobox is on the main and two comboboxes on the subform, you would need to have something like this to reference the subform combo boxes:

Forms!Mainform!Subform!Combo1.value

Put this in the criteria for your query that supplies the rowsource for a combobox in your subform
(Change name of Mainform and SubForm to your forms' names obviously)