ADP - Results when filtered don't update totals

[PeterOC]

Hi,

I'm working on an ADP on Access 2003 linked to SQL Server 2000.

I'm having a problem with a sub-form. There are several total's columns in this that do not update when the results are filtered.

I did a lot of searching on this issue and saw one site (which I now can't find anymore) that said that this was to do with the way adp fetch data from SQL server.

Does any one know how I can get the totals to update?

Thanks,

Peter

PS: Have been trying to use some variation of the following:

Dim sqlvar As String

Screen.PreviousControl.SetFocus
DoCmd.RunCommand acCmdFilterBySelection
'sqlvar = Me.Filter
'MsgBox sqlvar
Form.ServerFilter = sqlvar
Form.Requery

...but then I realised that the subform is based on a stored procedure so I can't apply a server filter.

I got some information from this thread...

http://www.thescripts.com/forum/thread512807.html

 

[PeterOC]

I didn't get any replies from this so I'm just re-posting to see if anyone can assist.