Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Parameter query (200)

    I would like to have an option on the switchboard that opens a form that has an option group where each option button would be one of the parameter selections in a parameter query. I would like to set up a macro to run the report according to the option selected. Is this possible? How would I set up the criteria for the parameter query?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Parameter query (200)

    An option group returns a numeric (long integer) value that is the OptionValue of the selected option button. How do you want to use this in the parameter query? Directly, or do you need to look up some other value based on the numeric value first?

Posting Permissions

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