I am new to Access programming and was giving the job of cleaning up the code of an old project. In this project, there a lot of forms that provide similar functionality using copy-and-paste coding, which I dislike. What is the normal way to handle such cases in Access?
To make things more...
RoyVidar:
Good guess, there is a trigger on the table and adding "SET NOCOUNT ON" in the trigger fixes the problem.
The VB codes does not, however. Adding the code without the Requery, causes no error to be displayed, but you still can't navigate away from the current record. Including the...
I am using an .adp Access file and I am having trouble editing records through it. My form displays the contains of a table one record at a time. When I try to edit one of the fields of the record, I get the following error after selecting Records>>Refresh or when I try to navigate to the next...