Enter Parameter Value on close in Windows XP

[JimAhl]

Enter Parameter Value error

I have a problem on one of my forms that is used for maintaining subcontractor info. I use a list box as record selector, and the data source is a query based on which sub is selected from the list box. The list box itself is populated by a query, which uses an unbound check box (IncludeInactive) on the form to either include or exclude active subs. It all works fine except when I exit. I have a close form button, and when ever I use it to close the form, it gives me an “Enter Paramet Value” message for IncludeInactive. I don’t understand why. The only place it is referenced is the listbox, and it is only used while selecting a sub. The really odd thing is if I exit the screen use the close window button, I don’t get the error. My close form button is a simple DoCmd.Close, and has no other code in it. Can anyone give me any ideas where to look. I have reviewed the little VB code there is, and I don’t see anything.

Any help would be greatly appreciated.

 

[Meltdown]

Have you checked the conditional formatting on the form?

 

[JimAhl]

Thanks for the response.

It is really a simple screen. And I have others like it that work just fine. However, I have just discovered something.

I am running Access 2000

I was testing it on an XP machine. I ran it on a 98 machine, and the error didn't happen. I tested on a few machines, and it seems it is a problem on XP only. Any ideads? I am going to check Microsoft to see if they have any answers.

 

[JimAhl]

Any help would be greatly appreciated.

I use Access 2000. I have a new form I just created that has a few list boxes on it. The list boxes are used for parameters for subforms within the same form. Everything works fine, but when I close the form I get a Enter Parameter Value for 2 of the list boxes. There is no code associated with closing the form.

The really puzzling part of this is that it only occurs in Windows XP. I have Windows 98 on other machines, and it doesn't happen on them.

Anyone else see problems like this in XP.

ps. I have SP2 installed on the XP machines.

 

[JimAhl]

Has no one else seen this problem?

 

[JerichoSteele]

Found this link in another thread... http://support.microsoft.com/defaul...kb;EN-US;811860

 

[JimAhl]

Found this link in another thread... http://support.microsoft.com/defaul...kb;EN-US;811860

Thanks for the response, but the link you posted is incomplete.

Could you please repost.

Thanks so much,
Jim

 

[godofhell]

You could turn off the system messages so that when you close the form no error will display even if it actually generates the error.

Sub Form_close()
DoCmd.SetWarnings False
docmd.Close
End Sub

 

[JimAhl]

I actually found the work around from Microsoft, and it was very simple.

DoCmd.Echo False
DoCmd.Close
DoCmd.Echo True

I did confirm that this is something that only happens when using Access 2000 with Windows XP.


Thanks for the help though.