Detecting duplicate entry

[Crackers]

I have a Form based on a table of current Players in a football league.
The Form is used to edit, but mainly add new registrations. The fields are...

Surname FirstName Address Suburb Age Club YearRegd

Is it possible in some way to have an alert or message come up stating that the Player is already registered if the Table already contains a player with the same Surname and FirstName only. This would need to happen after the FirstName has been entered as it is the second field after 'Surname'. I'm not sure if Access can do this type of function or not.

I've searched the Forums but have had no luck.

Any advice/assistance is greatly appreciated.

Thank-you very much.

 

[MStef]

Put this two fields as one INDEX, Uniyue = YES.