Hi, never having used Access before I've possibly unwisely agreed to write an Access 2000 invoice system for a customer within 2 weeks! 
All's going OK, except one thing - if I attempt to enter a record that contains erroneous data, the database rules force an error message (as expected). But try as I might I can't find an easy way to then clear that record! If it helps, what I'm after is the Access equivalent of the "clear record" command in Oracle, that just removes the screen info. The only way I've found is either quitting the form, or entering valid values, committing and then deleting!! I know there must be a command, but I simply cannot find it.
Cheers.
All's going OK, except one thing - if I attempt to enter a record that contains erroneous data, the database rules force an error message (as expected). But try as I might I can't find an easy way to then clear that record! If it helps, what I'm after is the Access equivalent of the "clear record" command in Oracle, that just removes the screen info. The only way I've found is either quitting the form, or entering valid values, committing and then deleting!! I know there must be a command, but I simply cannot find it.Cheers.
