I have a form which can either be opened to view data, or opened for data entry.
When the form has been opened in data entry mode, I need a way of telling if the record has been edited.
There is an autonumber field on the form, so I thought that if the record has not been changed, the the autonumber field will be null... Instead I receive an error telling me that an object is required...
How can I get Access to confirm if the current record exists or not?