Which fields are dirty in a dirty record?

[torok]

Hi all,

When my form opens it seems the record becomes dirty before any data is entered, and I can't figure out which field is the culprit. Is there some way to print the currently dirty record to the screen so I can figure out what's going on?

Thanks!

 

[DBL]

Have you set a default value in VBA that might be creating a new record straight away?

 

[torok]

Yup, thanks - turns out that was the problem. Took a while to find it though - developing Access apps can easily turn your program into a spaghetti-like code without careful attention to design.