after requerying my recordset sorts ie acending decending 1

[damabs26]

i have a form "unbound"
Within that form i have a subform based on a query.
i fill in data on the main form i.e text 1 to text 10 which is used by the query to retreave the appropriate records to display on the sub form.
After update events on the 10 text boxes requery the sub form, so the data displayed is correct. The query is not sorting in any order but when i requery it does sort acending/decending. This means the values in the 10 text boxes on the main form don't line up whith the coresponding values on the subform or though they are all there and correct. This is confusion the users. Can i force it to diplay them in the order i select them, like i do in the text boxes.

 

[allanon]

That is not so easy. What you would have to do is append something to each value of each that would force them to sort in the order you need.