Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005

    Unanswered: Printing search form Results

    I have created a search form that that houses a few combo boxes on change a new form is created that displays the choice, this works fine. However when I create a report based on the query It does not display anything but a empty template, how can I populate the report with the information pulled up from the search form.

  2. #2
    Join Date
    Sep 2003
    MN US

    Make sure the search form remains open. Then you can either...

    a) bind the report to the query and should work as you expect (assuming the query uses the combo boxes as criteria)


    b) create text boxes on the report that reference the form directly like
    = Forms!frmSearch!cboFieldName

    Let us know if you still have problems.


  3. #3
    Join Date
    Jan 2005

    Thankyou for your help

    I really appreciate your advice however I tried both the binding and the reference text box however neither of them worked. Im Starting to think I will need to write some VBA to Tell the report where to source its information. But would be massively grateful of any other ideas that you might have.
    Again many Thanks

  4. #4
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    What's the SQL for your report recordsource?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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