filtering continous forms

[madrappin]

I have a continous form with a few Count fields in the form footer. When I filter the form, it recalculates fine, however when I remove the filter it #Errors out all those fields I use at the bottom to make calculations. Any way around this?

 

[KenReay]

Have you tried executing a .requery after removing the filter ?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[madrappin]

How do you do that in Microsoft Access?

 

[KenReay]

Do you mean in code? Me.Requery or if it is a sub form, subformcontrolname.requery



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[madrappin]

Maybe I am putting the .requery in the wrong part of the code. Can you be a little more specific on what I should do here? I am pretty much only a basic access user, and any help would be much appreciated. Thanks.

 

[KenReay]

Hi

I can be more specific if you give more specific details of what you are doing, post the code (including event header) where you are removing the filter

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK