how to sort on a field in a form

I've a requirement to sort a field Assignment status on the Labor Scheduling form. Please help.

I set the value by going to Help-> Diagnostics -> custom Code-> personalize and under actions I selected the object type as Item and property name as Prompt_text and value as

select assignment_status from pa_assignments order by assignment_no asc.

But still getting un-orderly results