Sort order of subform

[marct]

Hi,

I have a database that consists of product codes and steps to make the products. On one form, you can select different product codes, and when a new one is selected, the corresponding steps are shown in a subform contained on the form. I have a table that contains all the steps for all the products, and when a product code is selected on the form, and the "Link" child & master fields are the product code (the prod code of the selections from the step table must correspond with the prod code on the form), and the steps are supposed to be displayed in order. Problem is, if I have 5 steps and delete step 3, then reenter a new step 3, the subform will display the steps in the order of 1,2,4,5,3. I can't seem to get it to display in order properly, where it will always display (in the subform) in order of step number. Although, when I look at just the table of steps, the records are separated by product code, then further ordered by step number. Why can't I force it to do the same thing on the subform?

Sorry for the length of the post, and thanks in advance for any help.

-Marc [sig][/sig]

 

[Rohdem]

Have you tried setting the Order By property on the subform to order by the step number? Also, you may need to refresh the subform after adding a record. [sig][/sig]