SubForm on Tab Control Issue

[Ima Lostsoul]

Access XP
Access 2002 format.
I have a subform on a tab control. The subform has the following
code (error trapping removed to make post shorter)... When I close the
parent form it goes 100% as designed UNLESS I have used one of the sort
buttons to sort the sub form on any given field. If I do sort, there is
a delay fo about 5 seconds until after the parent form closes and the
previous form re-opens. It appears that there may be some sort of save
going on. I don't want the sub form saved. I want it to simply close
along with the parent form and return to the previous form.

First, do you follow waht I just attempted to describe (I am not
all that good at describing situations sometimes)? Second, is there a
way to eliminate this delay?

Thanks,
DB
----- CODE -----

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open

Me.OrderByOn = True

End Sub
'Sorts on the Requested Field.
Private Sub bSortAscending_Click()

Screen.PreviousControl.SetFocus
Me.OrderBy = Screen.ActiveControl.ControlSource

End Sub
'Sorts on the Requested Field Descending.
Private Sub bSortDescending_Click()

Screen.PreviousControl.SetFocus
Me.OrderBy = Screen.ActiveControl.ControlSource & " DESC"

End Sub

----- CODE -----

[Larry Linson]

Well, one approach would be "don't use the sort buttons...". I think you'll
find they alter the Filter property, and it may well be saved. Perhaps you
might consider setting the Filter property of the Form embedded in the
Subform Control to "" in the Close event of the main form -- I'm not sure
that will prevent the save, but it will prevent the Filter from being
automatically applied the next time you use the form/subform.

As an alternative to using the sort buttons, you could add your own button
to recreate the RecordSource with a different GROUP BY. Overall, that may be
no more efficient, but it might eliminate the delay at closing.

Larry Linson
Microsoft Access MVP

"Ima Lostsoul" <[e-mail]> wrote in message
news:MP************************@netnews.comcast.ne t...

Access XP
Access 2002 format.
I have a subform on a tab control. The subform has the following
code (error trapping removed to make post shorter)... When I close the
parent form it goes 100% as designed UNLESS I have used one of the sort
buttons to sort the sub form on any given field. If I do sort, there is
a delay fo about 5 seconds until after the parent form closes and the
previous form re-opens. It appears that there may be some sort of save
going on. I don't want the sub form saved. I want it to simply close
along with the parent form and return to the previous form.

First, do you follow waht I just attempted to describe (I am not
all that good at describing situations sometimes)? Second, is there a
way to eliminate this delay?

Thanks,
DB
----- CODE -----

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open

Me.OrderByOn = True

End Sub
'Sorts on the Requested Field.
Private Sub bSortAscending_Click()

Screen.PreviousControl.SetFocus
Me.OrderBy = Screen.ActiveControl.ControlSource

End Sub
'Sorts on the Requested Field Descending.
Private Sub bSortDescending_Click()

Screen.PreviousControl.SetFocus
Me.OrderBy = Screen.ActiveControl.ControlSource & " DESC"

End Sub

----- CODE -----

[Ima Lostsoul]

Thanks Larry... The sub form has numerous fields that the client wants
to be able to sort on. I THINK I may have found a fix. I'll post an
FYI when I get the project done. This is a electronic audit workpaper
system that I am writing. Them audit types like sorting and poking at
data ya know! They are paying me well so I'll code whatever the heck
thay want. :)

:)

In article <dG*****************@nwrddc01.gnilink.net>,
bo*****@localhost.not says...

Well, one approach would be "don't use the sort buttons...". I think you'll
find they alter the Filter property, and it may well be saved. Perhaps you
might consider setting the Filter property of the Form embedded in the
Subform Control to "" in the Close event of the main form -- I'm not sure
that will prevent the save, but it will prevent the Filter from being
automatically applied the next time you use the form/subform.

As an alternative to using the sort buttons, you could add your own button
to recreate the RecordSource with a different GROUP BY. Overall, that may be
no more efficient, but it might eliminate the delay at closing.

Larry Linson
Microsoft Access MVP

"Ima Lostsoul" <[e-mail]> wrote in message
news:MP************************@netnews.comcast.ne t...

Access XP
Access 2002 format.
I have a subform on a tab control. The subform has the following
code (error trapping removed to make post shorter)... When I close the
parent form it goes 100% as designed UNLESS I have used one of the sort
buttons to sort the sub form on any given field. If I do sort, there is
a delay fo about 5 seconds until after the parent form closes and the
previous form re-opens. It appears that there may be some sort of save
going on. I don't want the sub form saved. I want it to simply close
along with the parent form and return to the previous form.

First, do you follow waht I just attempted to describe (I am not
all that good at describing situations sometimes)? Second, is there a
way to eliminate this delay?

Thanks,
DB
----- CODE -----

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open

Me.OrderByOn = True

End Sub
'Sorts on the Requested Field.
Private Sub bSortAscending_Click()