W Why Me? New member Local time Today, 16:46 Joined Jun 28, 2001 Messages 5 Jun 29, 2001 #1 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.
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.
D D-Fresh Registered User. Local time Today, 16:46 Joined Jun 6, 2000 Messages 225 Jun 29, 2001 #2 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
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
W Why Me? New member Local time Today, 16:46 Joined Jun 28, 2001 Messages 5 Jun 29, 2001 #3 Thanks! The code worked great...
