Datasheet View Empty Fields-Dirty

[isorders]

I have a datasheet input form. If the user tabs to the next record but nothing is entered the record shows as dirty on save, add, close, etc and an error script pops open until the user manually clicks in a previous record.
It is annoying to always get this message but necessary for data integrity. I have tried resetting the focus when the save button is clicked with no luck, it still activates the dirty script.
If anyone has any insight on how to get around this, I would appreciate it.
Thanks

 

[LarryDeLaruelle]

Not sure if it will solve you're problem but you might try setting the cycle property of the form (on the other tab) to current record. This will prevent the cursor from moving to the next record after the last field.

Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[isorders]

No luck...thanks though.

 

[isorders]

I always feel like the answers are obvious after I figure them out...I ended up using the subform on Exit with an acPrevious record. I have some code that ensures there is at least one record and that the current record values are all blank before I run the acPrevious.
It works great.
I read a comment about saying thanks and helping others...so thank you very much to all who post to this site. For those of us that are programmers by example, our apps would never materialize without your help and knowledge.