Option Button as Query Sort Parameter

  • Thread starter Thread starter Barkley via AccessMonster.com
  • Start date 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
 
Use a calculated field in your query ---
SortOrder: IIF([Forms]![FormName]![Frame1] = 1, [Field_X], [Field_Y])
Nest more IIF's for more sorts.
 
Back
Top