Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Location
    Fort Worth, TX
    Posts
    43

    Unanswered: ComboBox Filter to include (all) records

    I have a form that shows client shipments in transit. The form has a combobox that filters a subform to whichever client is selected showing only their shipments. I would like to simply add a field "(all)" to the list of client names in the combobox that shows all shipments when selected.
    is this possible?
    I am looking for a simple solution, please

  2. #2
    Join Date
    Oct 2009
    Posts
    340
    kind of depends on how things were initially set up.

    the normal combobox set up, using the wizard - doesn't involve a subform.


    the combobox is in the main form and also selecting a new record in the main form at the same time?

    is the subform sourced on a stand alonge query as its record source?

    passing a wildcard may be possible but can't really say at this point....one could of course jump out of the current form to generate a different object with all the data upon selection of All. So one way or another it is possible, but the specifics of how to go about to do it will depend on what you have now.

    sorry not to be more helpful.
    www CahabaData com

  3. #3
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Have a nice day!

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
  •