If your validation can be done in the table, that is the best choice. Jet will enforce your validation rules no matter how the table gets updated. But, alas, Jet doesn't support triggers so it is far less flexible than other RDBMS' and so you will probably need to do much of your validation in form events.