Sorting a report by an option button value

[Alex Martinez]

Hello,

I have a form that uses an option buttons there is about 10 option button
all tying into one field called auditType. When I want to print a report I
would like to have the report print ascending based on the value of the
auditType. For example if I select auditType 5 I want the report to start
to sort by the value 5 ascending. I can do this by query, but I rather code
it. Is this possible? Thank you in advance.

 

[Duane Hookom]

Are you trying to search be values in a single field or by one of several
fields? Allen Browne has some sample code on setting the sorting dynamically
at http://allenbrowne.com/ser-33.html.

 

[Alex Martinez]

Both Duane, Thanks for your help. I will check out Allen Browne website.