Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012
    Posts
    2

    Unanswered: selecting

    I have a form with two combo boxes (Wholesaler and Store). In the same form I have a table in datasheet view as a sub-form which shows all Wholesalers and all Stores. I want to be able to select a Wholesaler and a Store and I want the table to show only the entries matching that criteria. Any suggestions?
    Last edited by wilburc; 07-20-12 at 18:24. Reason: pasted wrong text

  2. #2
    Join Date
    Jun 2012
    Posts
    85
    set parameters to the subforms table.

    Forms!Tablename.Form!Wholesaler

    Forms!Tablename.Form!Store

    Table name should be the Origional table. you have .form to show the information passsing through a subform. now wholesaler and store, those are the names of the combo boxes where you select the the values. At the end of the combo boxes you can set up code for after update.

    Docmd.me.Requery, this will essentailly refresh the table, therefore searching the data

    Good luck.
    Mike
    ________

  3. #3
    Join Date
    Jul 2012
    Posts
    2

    thanks

    Excellent, will do. Thanks Mike-

Posting Permissions

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