Hi, thank you for both replies.
Shaggy Hiker: - Sorry i misunderstood your question. Ok i understand i have tryedd and tryed still found no real answer to what i need to do.
jasonwucinski : - The problem is we started off using auto number and then he said your not aloud to use auto number now but keep it as a primary key because the table needs a primary key. Yes my lecture did say that not to use it! So now i am trying to figure out a way around my program to stop it crashing or replacing one of my records.
For instance if i already have a member id with 1 in and a user tries to input 1 then basically it replaces it which is a major problem.
We are making a form which does multiple things so now i am just basically trying to find away around the user entering a number that already exists in the database! I would like maybe a message box to appear saying this already exists but i have searched and searched and i am still stuck!
I would really appreciate some help on code or something just to make it work i am literally pulling my hair out now over this problem.
Thank You