Two probems ?

[andrep]

I have a subform with a key field set to no duplicates!

Is the user accidently enters the same key number on another line in the subform, there is a violation of duplicates! The problem is that the subform will not
allow me to change that number to another! Is there any
way to handle this ?????

2. When i leave the subform i need to goto a control on the main form to perform calculations! I have tried the after update but i keep getting the message cant go to the control!

Any help appreciated !

Thanks

 

[lameid]

1 Undo the record by hitting escape and start over

2 Use the lost focus event and the setfocus method.