I've also worked with Access and it isn't easy to make it idiot proof.
You can add events that'll save the record, anytime someone comes in and out of a field, but that'll take in typos like mad.
I find it best to put a search screen seperate, with a link to edit that particular record. It's a pain for the user, but relatively harmless to the data.
|