Results 1 to 2 of 2

Thread: Query criteria

  1. #1
    Join Date
    May 2002
    Posts
    19

    Unanswered: Query criteria

    How can I pass a variable (Whether it is a variant, or a string) that I have in code on a form to a parameter in my query I have created.

    Thanks

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    The simplest way to do this is load your query into the code as an SQL statement and pass the variable in code.

    So a query might look like

    Select * from tblMyTable
    Where Name = MyParam

Posting Permissions

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