Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: Send query to a report?

    I have a form that allows the user to type in a unique number. Once the users presses return a couple of text boxes populate data from a table that is associated with that number. At this point I would like to press a button and send the results of the query to a the report. Is that possible? I have build the report and tied the record source to the query but I don't actually get the results. Any Help. Thanks.

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: Send query to a report?

    Yes you can you have to issue docmd.requery in your code before you can send that query to the report.

    Originally posted by tjarvas
    I have a form that allows the user to type in a unique number. Once the users presses return a couple of text boxes populate data from a table that is associated with that number. At this point I would like to press a button and send the results of the query to a the report. Is that possible? I have build the report and tied the record source to the query but I don't actually get the results. Any Help. Thanks.

Posting Permissions

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