Hi

I'm trying to get a query to handle a input box like so:

Code:
'input box for w/c

inputdate = InputBox(Prompt:="Enter Mondays date", Title:="date Input")


    
    
'SET DB AND FIELDS

Set db = CurrentDb
    
'Set rs = db.OpenRecordset("SELECT * FROM tbl_Schedule WHERE (((tbl_Schedule.Date)='& inputdate &'))")


I notice that the query works in this format:

Code:
 Set rs = db.OpenRecordset("SELECT * FROM chaseupEmail WHERE (((chaseupEmail.Date)=#14-may-12#))")
But when I enter the date 14-may-12 in the input box, the query does not recognise the date.

Any help would be greatly appreciated
Matt