I'm trying to make this form so that you can select a vendor and filter the parts or select a part and filter the vendors. I have the first part functional but when I try to select a part it wasn't autofilling vendor so I tried this code:
Private Sub cmbPartName_AfterUpdate()
Me.cmbVendor.RowSource = "SELECT [Vendor ID], [Vendor] FROM [Vendor] WHERE [Vendor ID] = " & Me.cmbPartName
Which seems to muck everything up. Am I using the wrong syntax?