I am new to this but as part of my new job I have develop a database in MS Access XP using the VB editor within it. My Problem is this, I have a save button within my form, I want an OK/Cancel message to appear on screen. When I put the code in my sub to display a message it does! But i cannot add an IF statement to the code, when I do there is always a compile error, I have tried to declare my variables but this doesn't work either. Is there any chance someone would be kind enough to supply me with some code which will allow me to do this. I cannot use SQL as it is not allowed to be installed on me computer.