I have a Query that I can open normally in Visual Basic.
I use the command :

Set rst = DB.OpenRecordset("NewSong")

However I want to set a filter on this Query. I already have the "CRITERIA" on the field I want to limit set to ">= [NewDate]" however I don't know how to pass the Date I want "NEWDATE" to be equal to. Can anyone help with this seemingly simple task?