Addnew empty row - how to cancel
When a user starts to add a new record,(which results in an AddNew for
the adodc recordset) and then changes their mind and wants to just go
back to another record, they cannot leave the new empty record. They get
a message "Cannot insert an empty row - must have at least one column
value set" and they are stuck on that record. The only thing they can do
to get off that new empty record is Close the form or Press the
"Refresh" button for the ado. I'm looking for a way to
make this more user friendly.
Firstly, is there an easy way for me to tell in advance if the record is
empty, or if the user has not entered values into any controls?
I thought that if I could detect the situation ahead of time, then I
could avoid the attempt to update the recordset.
The other angle I thought of was to try to trap the error before it goes
out to the screen and then do a "Refresh" under the covers, but I seem
not to be able to do this.
Any insights, comments or suggestions would be much appreciated. Thanks
in advance.
Christine
Sent via Deja.com http://www.*-*-*.com/
Before you buy.