Parameters being asked for When Closing Form

[dots]

Hi,

I have a form that contains 2 combo boxes - cboCostCenter and cboMachineCenter. cboMachineCenter is dependent upon the value selected in cboCostCenter. There is a Close button on the form.

In the On Current event of the form, I have the following:

cboMachineCenter.Requery

On its own, the form works perfectly. But,I added it as a button option (open form) on my Switchboard, and now when I close the form, it asks for a parameter for cboMachineCenter. It still behaves fine when I open it manually.

Does anyone know what could be causing this???

 

[VBAPrincess]

I've had that kind of thing happen to me before too, but maybe not for exactly the same scenario. Have you tried moving the requery code to the AfterUpdate event of the cboCostCenter? Then it only requeries when the user actually selects cboCostCenter.

I have one project that has serious "ghost" issues and sometimes I have problems after going back and forth in break mode too many times and making modifications. I think Access remembers my previous errors and comes back to haunt me with them. (I am too anal about fixing things at the exact moment I realize or decide that they are wrong or should be done differently -- I think I freak out my VB editor alot)

There's always the classic "reboot" option too -- just close your db, do a little dance, shout "PLEASE", and open it again. Sometimes I think that really works!

Diana

 

[dots]

Thanks for your reply.

I think my issues are more serious than I previously thought. Now I am getting an Out of Stack Space error when I try to add new controls to my Switchboard.

I'm going to try to copy all my data (except the Switchboard) to a new database.