Append Query

[Steven.Allman]

Seems simple, not sure what i am doing wrong here.
Just want to append a new record to the table, based on the criteria of he combobox player.
If I remove the WHERE from the SQL, then it loads the date and score once for each player.
What super simple thing did I miss?

golf.accdb

[Welshgasman]

Well you appear to be trying to compare a name to an ID?
The bound column is the PlayerID, so you need to compare against that?

Players is a name
Combo is an ID

INSERT INTO rounds ( Round, points, player )
SELECT [forms]![score_entry]![text5] AS Expr1, [forms]![score_entry]![text3] AS Expr2, players.players
FROM players
WHERE (((players.players)=[forms]![score_entry]![combo1]));

[Steven.Allman]

Bingo..
thanks buddy