Error: You have canceled previous operation.

[CraigWarmy]

Does anybody know what this is. There is no help available.

 

[KenHigg]

You'll have to describe the series of events that occured before the error.

 

[CraigWarmy]

Just trying to open a form. Docmd.OpenForm "frmPricing",acNormal

 

[KenHigg]

Is there any code or macros running in any of the form or object events like in the form OnOpen event?

 

[CraigWarmy]

yes. There is a bunch of code, but the one line of opening the pricing form get's the error.

 

[KenHigg]

You'll have to back up through your code from there. It would be useless speculation to guess what's going on. I've seen similar error messages when say a form tries to save a record when you close it. That may be a starting point...

 

[boblarson]

Ken, pardon me for jumping in, but if I might jump in really quick - There is a spot which seems to have this error more than most. It is when a DLookup returns a NULL. So, check for any DLookups and make sure you have used the NZ function with them to deal with nulls.

 

[CraigWarmy]

Yes I am already working on the replacement form. Fortunetely it does not have to much coding on it.