simple form sorting trouble

[xed80]

thanks Allen!

i have to admit that i´m a newbe to access and can´t figure out why it
returns an error message when i use the code you provided it goes a
something like this: "Me" is not recognized as a macro. Could you be a bit
more specific where to enter the code you gave.

The code: Me.OrderBy = "[NameOfYourYesNoFieldHere]"
Me.OrderByOn = True
thanks

Xed

 

[Allen Browne]

Yes, set the On Click property of the button to
[Event Procedure]

Then click the build button beside this (...).
Access opens the code window.

Paste the 2 lines in between the "Private Sub..." and "End Sub" lines.

Replace "NameOfYourYesNoFieldHere" with the name of your yes/no field.