Saving sort order of continuous subform

[Yair Sageev]

Greetings all,

I have a continuous subform consisting of a description and a descriptionID.
The descriptions are all entered in the correct order and have continously
ascending description ID's when I look at the table. However, when I open
up the form the order of the descriptions is not the order of the
descriptionID's.

How do I save the sort order of the form (and also of its report)?

Thanks in advance.

 

[Douglas J. Steele]

Never assume anything about the order of records in a table. Think of
relational database tables as "sacks of data": the information is put in
wherever it fits.

If the order is important, create a query with the appropriate ORDER BY
clause, and use the query as the recordsource for the form, not the table.

 

[Yair Sageev]

Thanks.

The only problem is that I need to update data in the form can I do that
with a query as the recordsource?

I tried setting the orderBy property of both the table and the form to
descriptionID and it doesn't work.

 

[Douglas J. Steele]

As long as the query is updatable (and it should be if you're only querying
a single table), there's no problem updating the data on the form.