Append query only adding one record meeting criteria rather than all records

[fishermanrow]

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.

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]));

[Welshgasman]

Why are you using Like if you want Equal?

Run the Select query on it's own and see what is returned.

[Welshgasman]

Crossposted https://www.utteraccess.com/topics/2060177?post=unread

[fishermanrow]

The advice here helped point me in the right direction. My PBGC.BRAND was set as the primary key. Changing the primary key to a field that will contain unique values produced the result I was needing to see. I am building something rather complicated with no formal training and I am piecing everything together through lots of trial and error. Thanks for all the replies and sorry to waste everyone's time with something so basic.