Sub Form Data Order

[Guest]

I have a sub form that has rows of data and I need it sorted in [Status Date]
order.

I have put the following statement into the sub form "FORM" proterties
against "Record Source", however while it returns the data it's sorted as per
the table.

SELECT * FROM [SIP Status] ORDER BY [SIP Status].[Status Date] DESC;

any ideas?

 

[Guest]

Try using the form's OrderBy property on the data tab.

Barry

 

[Guest]

Tried - didn't work.

Try using the form's OrderBy property on the data tab.

Barry

I have a sub form that has rows of data and I need it sorted in [Status Date]
order.

I have put the following statement into the sub form "FORM" proterties
against "Record Source", however while it returns the data it's sorted as per
the table.

SELECT * FROM [SIP Status] ORDER BY [SIP Status].[Status Date] DESC;

any ideas?