I am getting the message "Do you want to rename the record?" when ever Iam inserting a new record. Even though the record is getting updated I want to overcome the message.
The message means that after inserting a record you are modifying the primary key.
If you are sure you have inserted a new record then you will need to look at the order you are entering the data into the table. it may be that you are inserting a record with a blank in part of the primary key and then entering data into that field.
You could look at the Primary key for the table to work out what's happening.
I suppose you add a record programmatically?
If this is the case, just before the procedure is finished and the controlling goes back to the user, put a "CurrForm.UPDATE(FALSE);"
Regards,Alain Krikilion No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Comments
If you are sure you have inserted a new record then you will need to look at the order you are entering the data into the table. it may be that you are inserting a record with a blank in part of the primary key and then entering data into that field.
You could look at the Primary key for the table to work out what's happening.
regards
Ian
Ian
If this is the case, just before the procedure is finished and the controlling goes back to the user, put a "CurrForm.UPDATE(FALSE);"
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!