Write Conflict Error Message 3

[hsp7777]

Greetings,
I have a question regarding the "Write Conflict" error message box in Access 2000. I have a main Data Entry form that is bound to a table called, "Loan". I also have a secondary popup form that displays when the user presses a command button on the Data Entry form. This second form is also bound to the "Loan" table. When I press "OK" on the second form (to save any changes I have made), I receive the "Write Conflict" message box. If I press the "Save Record" button on this message box, however, my changes are saved to the Loan table (which is what I want). I was just wondering if there is any way to hide the "Write Conflict" message box so that the record is always saved? Any suggestions?

Thanks in advance!

hsp7777

 

[willir]

hsp7777

You are causing your own conflict...
- opening the main form referencing Loan table
- popup form also referencing Loan table

The reason you get the conflict is to avoid over-writing one change with another.

Imagine on a network...
- John instructs Jim to make a change to the phone number. Jim open the form an and starts to update the loan table.
- At the same time, Sally, a co-signer instructs Leslie to also make a change to the same loan.

Now Leslie savse the changes first. Followed by the change Jim.

Guess what, Sally / Leslie's changes are gone -- overwritten by John / Jim.

You don't want this.

As a work-around, add a command button, and use the wizard to create "Form" -> "Refresh". The refresh will write the data to the table. Then open the popup. Or include the code in the popup to "Refresh" and then Open the form with one button.

Richard

 

[hsp7777]

Thanks so much for the info. However, when I create a command button on the form, the wizard never displays. From what I can see, the wizards seem to be installed. Is there an option to turn wizards on and off?

Thanks!

hsp7777

 

[RoyVidar]

Second button on the "Toolbox" toolbar, should turn the wizards on and off.

Roy-Vidar