Subform Records Not Staying In Order of Key Field

[RobAccess]

Help Please.

I have a main form (Tasks) with a subform (task updates).

The underlying tables are set up with auto number key fields.

The problem is that the subform records are not staying in the order of the key field. Even when I run a query listing the update records the numbering is not in order. The table property indicates that the table order by property is set on the key field.

Anyone know now how I can get the updates records to stay in number order(i.e. the order in which they aer entered).

Any suggestions would be much appreciated - it's driving me mad trying to find the solution.

 

[Fuga]

Just a thought;

Have you checked the order by property of your subform?

Fuga.

 

[RobAccess]

Fuga

Many thanks for you response. I did set the subform Order by property to tblUpates.ID (i.e. the key field for table) but it doesn't do the trick.

Good thought though.

 

[GKite]

If the form data is tied directly into the table, you might try making a query, then tying the form to that query. This way you could set the field of your choice to be in ascending order.

 

[RobAccess]

GKite

Many thanks. I thought about doing this at some point but talked myself out of it for some reason.

However, your suggestion prompted me to try it again and I think it may be the answer.

Thanks for your response.