My subform does not want to sort correctly.

E

Eric

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?
 
D

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.
 
E

Eric

Table.

Douglas J. Steele said:
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.
Click to expand...
 
Top