Option Button as Query Sort Parameter

  • Thread starter Barkley via AccessMonster.com
  • Start date
B

Barkley via AccessMonster.com

Is it possible to use an option button as a query sort option?

I have a form with two option buttons... when one option button is clicked I
want my query to be sorted according to that... any ideas?

Thanks
 
G

Guest

Use a calculated field in your query ---
SortOrder: IIF([Forms]![FormName]![Frame1] = 1, [Field_X], [Field_Y])
Nest more IIF's for more sorts.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Option Buttons to Modify a Query 1
option buttons not showing that they are selected 4
Sort form and remove sort 2
Option Group Type Mismatch 1
Query Parameter using multiple options 0
Printing Preference 7
Evaluating multiple option buttons on a subform 3
datasheet: ¿how to order by the 2nd column of a combobox? 1

Top