POST your SQL.  (View: SQL in design view)

Try
CDate([Enter Date])

Access may not be understanding your input as a date.  It could be changing
11/07/2007 to a small fraction (11 divided by 7 divided by 2007) which the
date field will then see as a date and time on December 20, 1899.

Another way to handle this is to declare the parameter

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2

Now Access will know that [Enter Date] is a datetime and not a string or a
expression to be calculated.