Question how to check whether the record already existed in ms-access database

[Adam Insyirahnadia]

when a save button clicked, the username textbox is added to the database otherwise if the username already existed then a message appeared to tell user it is already taken.. any example please..tq

 

[jmcilhinney]

You simply query the database. How would you usually get a record from the database by username? That's exactly what you do here. If there is no matching record then you know the new value is not a duplicate.

 

[Adam Insyirahnadia]

I solved the issue.. Tq for the advice