Subform not sorting correctly

[kaiana]

I have a subform that is not linked to the main form as the all the main form has on it is an unbound text box and then the subform queries a table based on the date entered in the text box. Everything is working beautifully except that the subform is not sorting based on the criteria and can't work out why. I have used this before on a normal form and works fine.

Here's what is in the Record Source of the Subform.

SELECT [Forums].[ParticipantID], [Forums].[ForumDate] FROM Forums WHERE ((([Forums].[ForumDate])=[Forms]![Forums]![Text18])) ORDER BY [Forums].[ParticipantID];


Any Assistance would be appreciated