Form Not Closing with Code

[PJFry]

I am new to Access 2007. I have build a form that allows a user to view
projects that are either open or closed. The OnClick event for open projects
I have this code:
DoCmd.OpenForm "fProjects", acNormal, , "lngStatus = " & 0

and this for closed:
DoCmd.OpenForm "fProjects", acNormal, , "lngStatus = " & -1

The form opens properly for each. On fProjects I have a command button to
close the form. If I open a closed project the command button to close
fProjects does not work. It is as if there is no code behind the buton. The
open projects works fine, even though it is the same form. The only
difference is the where clause it use when opening it.

The only way I can close the form is the close all of the tabs or the
database itself.

Any thoughts?

Thanks!
PJ

I am using Access 2007 with XP Pro, SP2.

 

[Lord Kelvan]

whats the code you have for closing a form