Close form wihout saving data command button

[fatboy]

I need to code a command button to close a form without saving any selected data to the bound table..
In effect a cancel button.
I'm a newbe to VBA, so would appreciate any help.
Thanks in anticipation,
Fatboy

 

[A real begineer]

If you have access 2000, the auto complete function shows you how to code this function.

When I wuz really green, and did not even think of places like this forum, I use to use the button wizard to make lot's of buttons, and then copy the code, modifying one thing at a time until it did what I wanted.

 

[charityg]

If you don't have Access2000 and still need help with this, search for help on "Dirty". I know if you've never heard of this property it sounds funny, but it's the property that detects changes made to a form. I think the example should have the code you need.

 

[ElsVanMiert]

If you do not want to use unbound forms for data entry then you should use the code of the USA ACCESS Encyclopedia F19 (see www.unsoftwareag.com)

 

[fatboy]

Thank you all for your help, I have now resolved this problem