MSACCESS.exe process won't stop

[Guest]

The MSACCESS.exe process doesn't stop when I close access. This only occurs
when I open a specific sub-form but I am having trouble isolating the line
of code that is the cause. I have error handling and there appears to be no
error occuring.

I am starting to think that it may not be a line of code at all and maybe
something about the form itself that is causing the problem.

Has anyone experienced this or have any idea what could be the problem?

I am running access 2003 developer with windows XP

TIA,

Tim J

 

[Douglas J. Steele]

The MSACCESS.exe process doesn't stop when I close access. This only
occurs when I open a specific sub-form but I am having trouble isolating
the line of code that is the cause. I have error handling and there
appears to be no error occuring.

I am starting to think that it may not be a line of code at all and maybe
something about the form itself that is causing the problem.

Has anyone experienced this or have any idea what could be the problem?

I am running access 2003 developer with windows XP

Check whether you've got any code that refers to boolean values in If
statements without comparing them to a value.

Something like:

If Me.Parent!Checkbox1 Then

Change that to

If Me.Parent!Checkbox1 = True Then

 

[Guest]

I don't see any.

It happens when the subform is opened.
I checked the event that opens the subform, the subforms open event,
oncurrent event, gotfocus, and any event that could be initiated when the
form opens.

Could it be something else?

 

[David W. Fenton]

Check whether you've got any code that refers to boolean values in
If statements without comparing them to a value.

Something like:

If Me.Parent!Checkbox1 Then

Change that to

If Me.Parent!Checkbox1 = True Then

Or:

If (Me.Parent!Checkbox1) Then

That forces evaluation and removes the implicit reference issue.

I believe

If Me.Parent!Checkbox1.Value Then

would accomplish the same thing.