Error sorting subform in Windows 2000 (Access 2000)

Topic

New Reply

Hi,

One of the applications that I developed and am responsible for maintaining has several subforms who’s sort order is controlled by an OptionGroup on the main form. The code used is as follows:

Private Sub optSortByItemNumber_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)

‘ Sort produce item listing by item number.
Me.sfrMaintainProduceItem.Form.OrderBy = “ItemNumber”

End Sub

Private Sub optSortByItem_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)

‘ Sort produce item listing by item description.
Me.sfrMaintainProduceItem.Form.OrderBy = “Item, ItemNumber”

End Sub

Private Sub optSortByPLUUPC_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)

‘ Sort produce item listing by PLU/UPC.
Me.sfrMaintainProduceItem.Form.OrderBy = “PLU_UPC, ItemNumber”

End Sub

Recently several of the sites where this program is deployed have upgraded from Windows 95 to Windows 2000. At these sites, the users are now unable to sort the subform. No mater which option button is selected, the subform remains sorted in the default order. Those sites that are still running Windows 95 can still sort the subform.

The application consists of a .mde file and a linked .mdb data file. The data source for the subform is a linked table.

Thanks for your help,

Vernon

Reply | Quote

Replies

I don’t know why you are having problems. The immediate thought I had was that you did not set the OrderByOn property, but from your description there was no change in the database, only the OS. However, as an experiement, immediately after:

Me.sfrMaintainProduceItem.Form.OrderBy = “Item, ItemNumber”

Try puttiing this:

Me.sfrMaintainProduceItem.Form.Requery

Reply | Quote

Actually, it turns out that I hadn’t set the OrderByOn property. It’s curious that it worked previously as an Access 97/Windows 95 & Access 2000/Windows 95 application.

Thanks for the help,

Vernon

Reply | Quote