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
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
