This error happens about 10% of the time. I've just lived with it as this part of the database is only accessable by myself. But it would be a good idea to get it sorted if someone has an idea.
This related to purchase oders and creating invoices.
The user selects the order from a list. Then presses the invoice button.
This button does two things: 1. Appends the associalted order number to the invocie entry table (and some other details). 2. Open up the invoice form.
On form load I have this code: DoCmd.RunCommand acCmdRecordsGoToLast. (this will go to the record that was just appended. so the user can edit some information.)
As I said earlier this code errors about 10% of the time. When it errors I just close the form and try again.
Either I need to change or improve this process. Any ideas would be appreciated.
Andy.