Options Group

[George]

I have a form based on a table with 4 fields,
"Part-Number", "Item-Name", "ATA-Chapter", "Fleet".
The form opens sorted by part number - I am trying to add
a set of group options buttons so I can get the form to
re-sort based on which button I select ie "Item-Name", or
whatever. How can I accomplish this ?
Thanks - George

 

[Michel Walsh]

Hi,


Through the form Filter and FilterOn, in the after update event of the
option group:

Me.FilterOn=False
Select case optionGroup
Case 4 ' ckButtonFleetIsCheck
Me.Filter = "Fleet ASC"
Case 3
....
End Select
Me.FilterOn=True




Hoping it may help,
Vanderghast, Access MVP