I have code refreshing the combo box: Me.cboInventory.rowsource = Me.cboInventory.rowsource
How is this bound? Rowsource property is the data source for the control list, not the ControlSource property, which indicates what the control is bound to.
I don't get why you are altering the recordsource for a subform to match the rowsource. Plus, you're trying to use the selected item from a list by referring to the Column of that list rather than the value chosen from the control. If it was appropriate to refer to the column of the list, you would also be required to refer to the row, otherwise you'd always get what's in the first (?) row.
Please don't say "doesn't work" - it doesn't help much. Try this (and note that I used code tags for more than a few lines)
Code:
Private Sub cboInventory_AfterUpdate()
Dim MyInventory As String
MyInventory = "Select * from ProductsT where ([ProductID] = " & Me.cboInventory & ")"
Me.DS.Form.RecordSource = MyInventory
Me.DS.Form.Requery
End Sub
However, I have to wonder why your subform isn't linked to your main form (see Child vs Parent properties for subform/form relationships) and the combo just chooses the value for that linked field. You'd still have to requery the subform, but why play around with form recordsources in this case?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.