Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    An all in one parameter query possible? (97)

    An all in one parameter query possible?
    I would like to use a default report to display results of a users search. On a form, a combo box would allow selection from one of several values, dealer#, invoice#, reference#

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: An all in one parameter query possible? (97)

    >>After a user selection from the combo box, a goButtonClick ought to ask for a parameter based upon the users selection from the combo box. Once the user enters that info & clicks ok, the report would pop up using the parameter info as the filter.<<

    I don't really understand what you are saying here. However, you can use the WHERE clause of the DoCmd.OpenReport method to effectively filter the report contents. Is this what you are looking for?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Re: An all in one parameter query possible? (97)

    Hi
    I would try and set up unbound combo boxes:
    Dealer, Ivoice, details

    The contents of cbox Invoice based on a query that took the value of cboxDealer as input:

    Select blah
    Where varInvoice = forms!frmMyform!cboxDealer

    The on Change event of cboxDealer would need to requery cboxInvoice:

    frms!Myform!cboxInvoice.requery

    I think this technique will work for you
    Really interested in other's ideas.
    Cheers
    Geof

Posting Permissions

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