The line of code you use to change the sub form record source is
Code:
myBinLocation = "Select * from Inventory4Location where ([BIN Location]=" & Me.cboBin & ")"
The main problem is that the bound column of combo box "cboBin" is "ID" (a number) and the field "BIN Location" in the query for the sub form is text.
BTW, having "ID" as the name of the PK field for every table leaves a lot to be desired.
So you need to add "Inventory4Location.ID" to the query.
Changing the sub form record source is (IMHO) a PITA.
I would just set the filter property of the sub form.