MSACCESS.exe process won't stop

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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
 
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?
 
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
Click to expand...

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.
 
Back
Top