sorting a datasheet in a form

[scottappleford]

Hi

I have a datasheet subform on an unbound form. but the data on the subform will not sort in ascending order.

I have used the ORDER BY in the table and form but it still will not do it??

Thanks

 

[RuralGuy]

Have you tried basing your subform on a query instead?

 

[scottappleford]

Hi

I have heard of this alot - basing forms etc on queries but not sure how to do that?

Do i just create the query as i would the subform e.g. using the same fields and then let access create the link?

Thanks

 

[scottappleford]

Hi

Its funny because the subform sorts the fields - it is only when it is attached to an unbound form that it looses the sorting?

Thanks

 

[RuralGuy]

While looking at the Data tab of the property sheet for the SubForm, clicking the Builder button "..." on the RecordSource row will invoke the query builder. You can determine sort order in the query builder. When installed as a subform are the Link Master/Child fields empty or filled in?

 

[scottappleford]

Thanks it all works now - a neat tool - thanks again for the help.

The link master field were empty as the main form was unbound it was just to show the subform in a nicer way.

Thanks again for keep replying till i solved the problem!

 

[RuralGuy]

Glad I could help.