G
George Hester
Here is the issue. The DAP has one Group Level. I have the DAP set up so
that when a record appears which has a childsection that childsection will
appear automatically. I don't want all the records in the childsection
(corresponds to another Data Control appearing) but just want some of the
records. I used the Subroutine Find on it but still had access to records I
don't want in the childsection. So I used the Filer property. Cant't use the
ServerFilter property because that would destroy the Grid on the page. With
the Filter property I save the Grid but the darn section is blinking. In
other words the childsection appears then disappers, appears then
disappears...ad nauseum. I cannot even hit the Stop button on the brower it
just keeps blinking anyway. Any ideas how to stop it? Here is a snippit of
the code.
<SCRIPT language=vbscript event=DataPageComplete(oEventInfo) for=MSODSC>
<!--
Dim rs
On Error Resume Next
If MSODSC.DataPages.Count > 1 Then
'got the childsection's recordset rs
End If
'Little bit of other stuff here. Nothing of any significance I think.
If Not MSODSC.CurrentSection.IsExpanded Then MSODSC.CurrentSection.Expand
If Err.Numher = &H0000665C Then Err.Clear 'necessay becuase of timing
issues
If IsObject(rs) Then
txtName = "George Hester"
rs.Filter = "[Caption_Name1] = '" & txtName & "'"
End If
'Statements to catch errors and identify them
-->
</SCRIPT>
Now it does happen that this sub is called twice. When the page which has a
another datapage associated with it is navigated to and again because of the
Expand statement. But that is it. This blinking behavior does not occur when
Find is used on the Recordset rs. Just Filter so far that I have noticed.
Any ideas why it is happening or best know how to fix it? Thanks.
that when a record appears which has a childsection that childsection will
appear automatically. I don't want all the records in the childsection
(corresponds to another Data Control appearing) but just want some of the
records. I used the Subroutine Find on it but still had access to records I
don't want in the childsection. So I used the Filer property. Cant't use the
ServerFilter property because that would destroy the Grid on the page. With
the Filter property I save the Grid but the darn section is blinking. In
other words the childsection appears then disappers, appears then
disappears...ad nauseum. I cannot even hit the Stop button on the brower it
just keeps blinking anyway. Any ideas how to stop it? Here is a snippit of
the code.
<SCRIPT language=vbscript event=DataPageComplete(oEventInfo) for=MSODSC>
<!--
Dim rs
On Error Resume Next
If MSODSC.DataPages.Count > 1 Then
'got the childsection's recordset rs
End If
'Little bit of other stuff here. Nothing of any significance I think.
If Not MSODSC.CurrentSection.IsExpanded Then MSODSC.CurrentSection.Expand
If Err.Numher = &H0000665C Then Err.Clear 'necessay becuase of timing
issues
If IsObject(rs) Then
txtName = "George Hester"
rs.Filter = "[Caption_Name1] = '" & txtName & "'"
End If
'Statements to catch errors and identify them
-->
</SCRIPT>
Now it does happen that this sub is called twice. When the page which has a
another datapage associated with it is navigated to and again because of the
Expand statement. But that is it. This blinking behavior does not occur when
Find is used on the Recordset rs. Just Filter so far that I have noticed.
Any ideas why it is happening or best know how to fix it? Thanks.