Results 1 to 2 of 2

Thread: Opening a Query, and passing it a varible.

  1. #1
    Guest

    Question

    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?

  2. #2
    Guest

    Exclamation Oops, Forgot...

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width