Hi Guys,
I'm having a problem with a pair of combo boxes on my form. The second combo boxes values get filtered based on the selection made in the first combo box. The actual filtering does work, but when viewing the records the second combo box isn't synced and does not show the data unless I go back to the first combo and reselect it's value then the value in the second combo appears. I think I'm missing some small detail here. Here's the code from the first combo's after update procedure.
The first combo is cmbCardCategories and the second combo is cmbCardAttribute. Any help you can provide is appreciated.Code:Private Sub cmbCardCategory_AfterUpdate() cmbCardAttribute.RowSource = "SELECT lkpAttributes.[Attribute ID], lkpAttributes.Description FROM lkpAttributes INNER JOIN jctCategoryAttributes ON lkpAttributes.[Attribute ID] = jctCategoryAttributes.[Attribute ID] WHERE jctCategoryAttributes.[Category ID] = '" & cmbCardCategory & "' ORDER BY jctCategoryAttributes.[Category ID];" cmbCardAttribute.Requery CheckCardCategory End Sub