PDA

Click to See Complete Forum and Search --> : Opening a Query, and passing it a varible.


Sep 20th, 2000, 12:34 PM
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?

Sep 20th, 2000, 12:46 PM
I forgot to mention I am willing to NOT use a varible passed to the query if it is easy to use the "filter" command, however I can't quite figure that out either.