Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    List box on Form (2003)

    I have form that I will use as a report menu that has 4 list boxes and I have a command button that executes a query. Problem, I want to have the ability to choose any combination of choices - 1,2,all, or none in each of the 4 list boxes. I have the query set in the criteria by Forms!FrmReportMenu!cmbstate for one of the list boxes and this works when 1 is selected in the list box. However if I pick 2 or more from a lsit box ,nothing comes back from the query. Should I change the criteria on the criteria or is there something else I can do?

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

    Re: List box on Form (2003)

    See the thread starting at <post#=593,790>post 593,790</post#>.

  3. #3
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List box on Form (2003)

    Thanks I will see what I can come up with.

Posting Permissions

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