I have a text box that contains a number from one to four. When I view the records these numbers are never in order. How can I change it so that this text box always displays 1 first. I tried the order by property of the form but it doesn't work.

Two options here... Either sort your Recordsource by that field or in the Open event of the form put the following code..

me.orderby = "[TextFieldName]"
me.orderbyon = true

Hope one of these helps for you.

Doug

Thanks! The code worked great...