Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    1

    Unanswered: Transfer Query Results to Report

    I have a report that list milestones that is ran off a query. In the query I
    ask the user to: Like "*" & [Enter a Key Players Name:] & "*". I would like
    the name they enter to show up at the top of the associated report. Is there any code I can use to display the name at the top of the report?

    Thanks in advance

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    In the OnOpen event of your report, you could prompt your user for the Key Players Name using an input box (or your own custom input box). Then build your query in vb using this value, pass the SQL string to your report and place the value in a textbox or label.
    Me.Geek = True

Posting Permissions

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