Query for Combo box for subtype in MS access form

[Dschmer]

I have a code table that contains statuses and sub statuses. On my form I have combo boxes to list the options which works fine for status but I don't know how to code the query to filter my substatis based on the selected status in the form.
My code table looks like
Id Code type Subtype of descr
1 1 Open
2 1 Closed
3. 2. 2. Denied
4. 2. 2 Approved

So for the substatis combo box if the status is Closed I want to filter the drop down list to code type = 2 AND id = the current value of status. but don't know how to reference the current value of the status field in the query.

Thanks

[Tom Murphy]

This is called cascading combo boxes. You can filter the source for the second combo box in the on enter event procedure using vba or a macro. In VBA the current value of the status field is me.statusfieldname. In a quary the criteria for ID would look something like Forms!myform!statusfieldname.