13 Apr 12 11:46
Hi. I'm using Access 2010 and I'm stuck! I'm essentially putting together a system for booking jobs. I have a form for booking them (done and dusted) and a form for confirming a job as complete. when updating the job as completed, it needs to update TWO tables, including the jobs table.
Each job record has a marker for complete or not, and the form is bound to the jobs table with the criteria to show only ones that aren't complete. I have a [Complete] button next to each record that updates both tables and then refreshes the form. The record should be removed after the refresh as the complete marker is set to Yes.
When this happens I get a Write Conflict error. I know why it's doing this but I don't know how to get around it. It's a combination of using a bound form and code to update the tables. I'd like to NOT use a bound form, but I need to display the details for job before the complete button.
Another reason I'd like to not use a bound form is because some of the details, such as the person doing the job, should be editable, such as the time taken to do it, or the person doing it. I only want these details to be edited when using the button.
Can anyone offer any advice?
Knowing is not enough, we must apply. Willing is not enough, we must do.