I'm probably missing something basic here, but I can't for the life of me get this working.

I have a database that is tracking when certain projects are completed, and I want to be able to show in a list the completed projects between a date range.
The date range to check between is set by the user on a form.

I have built a query in Access:

> 
> SELECT Logs.Completed   
> 
>  FROM Logs   
> 
>  WHERE Logs.Completed BETWEEN Forms!UIBrowseCompleted!Text53 AND Forms!UIBrowseCompleted!Text55   
> 
>  ORDER BY Logs.Completed;
> 
> 
> 

I have got the dates formatted in the text box so they are in *#MM/DD/YYYY#* format (I have manually put these dates direct in the query and this works) but when I run the query I get the following error:

> 
> This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.
> 
> 
> 

I have tried modifying the query to take the *#* out of the text fields in the form, and including *'* around the Forms!UIBrowseCompleted!Text53 but I've still not got any joy from it.

has anyone had this issue before, or can anyone point me in the right direction.

Thanks