Searching Between Two Dates Via User Inut

Hey all i need to search for all records found between two dates and all i have been able to find is code that has predefined dates were i need user input.

Here is an example of my code, i got syntax error:

SELECT Applicant_Loan_Info.Submission
FROM Applicant_Loan_Info
WHERE (((Applicant_Loan_Info.Submission) Between #((([Submission]))=[Starting Submission])# And #((([Submission]))=[Ending Submission]#));

And if there is something obviously stupid with it, go easy, new at this.

Thnx in advance