Results 1 to 2 of 2
  1. #1
    davefrag is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    1

    Question Add selection to queried combo box

    On a form I'm creating, I have a combo box that populates itself with a client list from a query it's tied to. A report is generated based on the client that is selected within the combo box. I need to add a selection to the very first row of the combo box that would indicate that "All Clients" are to be used to generate the data for the report.

    Any and all suggestions as to how I can code this is appreciated.

    Thanks.

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    I would create a query and use that as the record source for the report. I would then create an unbound form that is used to set the criteria for the query. Look at this video on how Mike sets it up so that you can capture all the data by coding the criteria in the query correctly.
    http://www.datapigtechnologies.com/f...earchform.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 06-23-2014, 12:19 PM
  2. Replies: 33
    Last Post: 01-13-2012, 07:44 AM
  3. Replies: 1
    Last Post: 07-15-2011, 11:00 AM
  4. Replies: 1
    Last Post: 08-26-2009, 10:45 AM
  5. Replies: 3
    Last Post: 02-26-2009, 10:17 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums