Select Specific Fields of Query Based On Variable Field

[ahillenb]

I am creating a form to order baseball uniforms.

I have a dropdown in the form called "Style".
I have a bound field in the form called "Garment Type".

I would like the "Style" dropdown to show only shirt style options when the "Garment Type" value is "Shirts", and to only show pant styles when the "Garment Type" is "Pants".

I've been tinkering with the Record Source field in the property sheet for the Style dropdown, and searched around the net for a few hours, but haven't found anything I really understand. I thought I might get something by putting all the pant styles and all the shirt styles in one query, then somehow selectively picking from the query based on the garment style.

Any help would be appreciated.

Thanks