Trouble closing a form

[303factory]

I'm having trouble closing a form. My close button has the following code behind it:

Me.SIMPresent = True
DoCmd.OpenForm "frmSIMExaminationSetup"
DoCmd.Close acForm, "frmExhibitContents"

Me.SIMPresent is a tix box hidden in a header. If I comment out that line the form closes fine. However if I dont I get 'this record has been changed by another user' errors (drop changes, save changes, copy to clipboard etc)

If I try to use Me.refresh or runcommand acCmdSaveRecord before the form close then the error just occurs one line earlier.

I didnt have this problem when I used an access back end its started happening now I'm using MySQL. It seems I'm unable to dirty a form by code and then close it without an error! I can dirty the form by clicking on it and typing without any problems..

Any help would be appreciated.

303

 

[aman]

try to replace the two commands like this:

DoCmd.Close acForm, "frmExhibitContents"
DoCmd.OpenForm "frmSIMExaminationSetup"

see if it makes any difference.

Cheers

 

[303factory]

try to replace the two commands like this:

DoCmd.Close acForm, "frmExhibitContents"
DoCmd.OpenForm "frmSIMExaminationSetup"

see if it makes any difference.

Cheers

I'm afraid it doesnt make any difference :/

 

[303factory]

Investigating futher I tried building a much simpler version of my form.

I made a query with 1 text field, and a bound form with nothing but that field as a text box, and a close button.

Close button code:

Me.textBox = "blah"
DoCmd.Close acForm, "testForm"

I still get the problem! However it only occurs if the text field was already 'blah'. If I change it in the table to something else then run the code it doesnt give me the error. I think there must be something fundamentally wrong with my database...