adding data to table

[Gazza2]

I have a form for adding customers to a table which works well on its own but i have added a text box to the bottom for a simple y or n answer heres where my problem start if the user presses y it should add the details to the table but if the user presses n then it doesnt. Now whichever the user presses it adds the data to the table and moves to the next record.

Another small problem is that i cant figure out how to get a message box to pop up if the user enters a duplicate value into one of the text boxes on the form.

Any help would be much appreciated.

 

[Gazza2]

Thanks for the reply uncle gizmo. It makes things much easier when you know what to search for.
heres the link to the post that helped me solve the second part of the problem :-
http://www.access-programmers.co.uk/forums/showthread.php?t=142247&highlight=checking+duplicates

Now all i need is to be able to solve the first part and ill be sorted

Thanks again