Filter Query Dependent on Another Form Field

  • Thread starter Thread starter Debra Ann
  • Start date Start date
D

Debra Ann

Access 2003:

I have a form and two tables. One table contains two fields of information
to use as selections in the form. The form places in the selected choices
into the second table (a log). Example of info in first table to use a form
choices:

001 Printer
001 Fax
001 PC
002 Purchase Order
002 Contract
002 Order Form

The goal is for the user to select from a dropdown list in the form that
shows Column 1 grouped and then select the next field from a dropdown list
that only shows Column 2 fields that match with what was selected in the
first field. Example:

Form Field 1: User selects 002
Form Field 2: Dropdown shows only Purchase Order, Cotnract, and Order Form

I created a query from the first table so I could group Table Field 1 and
use it as a dropdown choice for Form Field 1.

Now I cannot figure out how to filter Form Field 2 to only show the three
choices.

Can someone please explain how to do this?

Thanks,

Debra Ann
 
Back
Top