Sub Form's ID# Not Sorted

[netchie]

Hello,



I have a sub-form where a tab is for ID#s with data. The issue is the ID#s are not sorted. How can I make them in order? Some of them have ID# 1-10 (sorted) then before the next will be ID#s 23, 24 then back to ID# 11-20.

By the way, data from sub-form is coming from a table. I wanted to sort the ID field name.

Please help!

Thanks,
Netchie

[pbaldy]

Either base the subform on a query that includes the sorting, or set the Order By property of the form.

[netchie]

Hi pbaldy,

Long time to talk

When you say set the Order By property of the form, where is that? Should I go to the property of sub form?

[pbaldy]

It's a property of a form, in your case the subform. You can set it in design view or in code.

[netchie]

Nevermind, I found it. What I have is

[tblID].[ColorID]

I guess it's not sorted by ID but ColorID so should I make it as [tblID].[ID#] instead?

[pbaldy]

Whatever field(s) you want the sort on.