Hello,
I would like to have a dynamic sort for a report I created. I know I could put buttons on the dialog box and have user select there, but I was wondering if there's a way for them to click on buttons while viewing the report at the same time (all in one window). I read a post where someone suggested having a sort button on the toolbar for the users; is this possible? User may need to sort on 3 fields at a time, so I will have to devise something that asks for sort1, sort2, sort3. If not the toolbar, can I have a floating little pop-up, and have the sort options on there? I sort-of like that idea.
Any suggestions? I am fairly new to Access... but am a programmer so am comfortable with the VBA part (that changes daily!).
Thanks all!
Lori
I would like to have a dynamic sort for a report I created. I know I could put buttons on the dialog box and have user select there, but I was wondering if there's a way for them to click on buttons while viewing the report at the same time (all in one window). I read a post where someone suggested having a sort button on the toolbar for the users; is this possible? User may need to sort on 3 fields at a time, so I will have to devise something that asks for sort1, sort2, sort3. If not the toolbar, can I have a floating little pop-up, and have the sort options on there? I sort-of like that idea.
Any suggestions? I am fairly new to Access... but am a programmer so am comfortable with the VBA part (that changes daily!).
Thanks all!
Lori
