When trying to insert a new row to the database (using acCmdSaveRecord), the form's fields are replaced by "#Deleted" and then the rest of the session is a disaster -- the application loses track of global variables after that, as it would after a crash, and nothing works right until they get out of the app and then start over. A co-worker suggested doing a form requery right after the save , but that only generates an "Invalid use of null" error. I heard this was a documented bug on Access, but I don't know how to get around it. Thanks for any help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Fields set to #Deleted, session gets corrupted
- Thread starter tpolony
- Start date
Similar threads
- Locked
- Question
- Question
- Locked
- Question