My subform does not want to sort correctly.

[Guest]

Hi, I am in need of some help.

I have a form with a subform connected by a field I call AuditID. We create
attribures from a table called tblAttributtes based on what AuditCategory is
entered in to our master table. Whenever I create a product to be audited,
close out of that form, go into the form with the subform, close out of that,
enter in another set of products, then go into that form, my AttributeID
numbers are not sorted correctly. It is hard to explain it, you'd hav to see
it for yourself.

They should be set up like this.
1,2,3,4,5-34

Instead only a couple show:

5,6,7,-34, 1,2,3,4

What am I doing wrong?

 

[Douglas J. Steele]

Is the subform based on a query or a table? If the latter, create a query
with the appropriate ORDER BY clause.

You can never make any assumption about the order rows will be returned from
a table.

 

[Guest]

Table.

Is the subform based on a query or a table? If the latter, create a query
with the appropriate ORDER BY clause.

You can never make any assumption about the order rows will be returned from
a table.

 

[Douglas J. Steele]

So did using a query solve your problem.