Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    2

    Unanswered: Sending parameter to query via vb - possible?

    Originally I had a form that passed a variable to the Query via 'Me!fromTime' on the form to 'Forms![testing]![fromTime]'.
    I now want to launch an acSendReport based on the query but launching from a Module.
    How can the query reference the modules parameter now it's not launching from a form. The 'Forms![testing]![fromTime] no longer works.

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    One way is to use the module as criteria for the query.

    The other way is to copy the SQL Statement behind the query into code. Personally I prefer this method.

  3. #3
    Join Date
    Jun 2002
    Posts
    2
    Thanks for that.

    How would I go about using the module as criteria for the query?

    I know how to reference the variable via the form, but how do I reference to the module?

    Any help would be appreciated.

Posting Permissions

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