When I put a Command Button such as "Add New Record" on my form and click on it in the form view, I always get the message " Compile Error Ambiguous name detected: Close_Form_Click" It also opens a screen with code on it. When I go to upper right box an click on the arrow, I see several instances of Add_Record_Click and Clos_Form_Click, etc. Any suggestions??

IM pretty new to access but had a similar problem, I had duplicate names, when I created a button to do something I named it then if it didnt work i deleted it without deleting the left behind code/sub routine so you prolly just have to go in and delete the routines that you dont use..make a backup of the code in case you delete the wrong thing...

HTH
if it doesnt ignore me =)

Rpb