subform sort (1 Viewer)

[Matthew Snook]

I have a form based on two tables:

Tbl_Entity
Entity_ID
Entity_Type
and various attribute fields

Tbl_Event
Event_ID
Entity_ID
Event_Date
and event attributes.

The two are joined one entity to many events through the Entity_ID field. The join works well, all associated events appear in the subform containing the "Events" table. But they are in the order entered. I would like to have them ordered by date. I have tried sorting the actual events table, applying an "Order By" in the sql statement. None of these have any effect on the order of records in the subform. What am I missing? There must be some setting that I have missed that is overriding these methods of ordering the records. Any ideas?

Matt

 

[RedSkies]

You could try entering [Event_date] in the "Order by" property of the form itself. I believe that overrides any other sort orders.

[This message has been edited by RedSkies (edited 05-16-2001).]