Philippe

In the report below the Sponsor Type dropdown is sorted based on the value of the SponsorTypeID and not its display value. This is working fine. Now I would like the report itself to sort based on the SponsorTypeID as for the dropdown but show the display value which is SponsorType. I could probably rename my SponsorType like 0 - Platinum, 1- Gold, 2- Silver and so on, but I think this is ugly and looking for a better solution. Thanks

Thanks @Glitch that worked perfectly. Also used the readOnly from the post you mentioned. Sorry @MayMusic I couldn't make your solution to work!

Thanks for your quick response, tbis is not a 2 page report - I use the one Display search form above the result, and don't have pass value to next page!

Hi there, On a report how I can copy the field value of my search once I click on Search into a data entry field. In the attach screenshot when I search my EventID I would like this value to be automatically copied the EventID input field below. Also when I click on Add to create a record based on my selection how can I keep the same EventID until I search for an another event? Thanks,