Confirm Save of Duplicate Record

[ortizimo]

I have a table with games and consoles and it has duplicate names of games because they come in different versions of the same console. I need a way to confirm that the game has been already entered for that console and do a yes/no to continue saving that record...thnx.

[RuralGuy]

It should all be done in the BeforeUpdate event of your form with a Domain function (DLookup, DCount) maybe.

[Micron]

Or a composite index could be created using the fields GameName and Console (or whatever you call them). Only if you attempt to add the exact pair of values would Access raise an error message. Alternatively, those 2 table fields could be a composite Primary Key. While some here seem to not like composite PK's, I've never received an explanation as to why not. In fact, I have read a forum post where Allen Browne offered a composite PK as a good solution. What's good for AB is good enough for me.