I have a form [frmPBGC] with a combobox [cmbPBGCbrand].
Once a user makes a selection within the combobox, the onclick event of a command button within the form runs an append query.
The goal is for the append query to add records to [PBGC] from [PBII] where the combobox selection matches a field in [PBII]. There are multiple records in [PBII] which contain a value equal to the combobox selection but for some reason only the first matching record in [PBII] appends to [PBGC]. Code below, any advice appreciated.
Code:
INSERT INTO PBGC ( BRAND, DESCRIPTION, UNITUPC, OLDRETAIL, NEWRETAIL )
SELECT PBII.Group, PBII.Description, PBII.UnitUPC, PBII.ActiveRetail, [Forms]![frmPBGC]![txtPBGCNEW] AS Expr1
FROM PBII LEFT JOIN PBGC ON PBII.Group = PBGC.BRAND
WHERE (((PBII.Group) Like [Forms]![frmPBGC]![cmbPBGCbrand]));