Hi,
I am facing a very bizarre problem in my Access 2000 database.
I have a form with a subform. After entering data in Main form,I have seen in very rare cases, a window opens asking whether to save the record or save to clipboard.
If I choose "save record" then in some cases, data in all the fields in the Main form including the primary index field vanish for this particular record but the corresponding entries in subform are still available. I am not able to enter/delete the primary index field of this particular record and when I try it, I get following message : SEARCH KEY WAS NOT FOUND IN ANY RECORD (ERROR 3709)and as per Microsoft help, this error occurs when ISAM SEEK is being executed.
I hope what I am writing makes sense as honestly I cannot make out what is going on!!
I would be very grateful for any expert advice about this strange observation.
Thanks
I am facing a very bizarre problem in my Access 2000 database.
I have a form with a subform. After entering data in Main form,I have seen in very rare cases, a window opens asking whether to save the record or save to clipboard.
If I choose "save record" then in some cases, data in all the fields in the Main form including the primary index field vanish for this particular record but the corresponding entries in subform are still available. I am not able to enter/delete the primary index field of this particular record and when I try it, I get following message : SEARCH KEY WAS NOT FOUND IN ANY RECORD (ERROR 3709)and as per Microsoft help, this error occurs when ISAM SEEK is being executed.
I hope what I am writing makes sense as honestly I cannot make out what is going on!!
I would be very grateful for any expert advice about this strange observation.
Thanks