Sorting a report by an option button value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex Martinez - 21 Dec 2005 04:01 GMT

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.

Reply to this Message

Duane Hookom - 21 Dec 2005 04:37 GMT

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.

Signature

Duane Hookom
MS Access MVP
--

> Hello,
>
[quoted text clipped - 4 lines]
> 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.

Reply to this Message

Alex Martinez - 21 Dec 2005 05:46 GMT

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

> 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
[quoted text clipped - 8 lines]
>> 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.

Reply to this Message