Hi ITG,

Which version of Access are you running?

Your basic problem is that when the app was built, certain fields were declared as mandatory, had a parameter check, or a data type check added to them.

You also seem to have an automatic record key generation routine running?

What seems to be happening is that when you try to skip a mandatory field it will "cough" if you try to delete the record, it has already assigned the unique number, and does not want gaps in the sequence..............or maybe the delete option has been disabled.

Are you using this in a "trusted" environment, or does it have to be idiot proof?

I will need to try out a couple of things depending on your version..............most of my development has been Office 4.3 or Office 97, but I do have 2000 and 2002 (XP).

Are you prepared to have incomplete records on your main database? In which case you can just remove the checks. Otherwise treat it as batch processing and create a mirror "Form" and "Table"....run an audit/update query against this "pseudo batch" table, and let the query update the main table with complete records.

I need a bit more information