Populating a combo box in a sub-form

[essence]

Good day,

I have a main form with project data and a sub form that has related financial information. Once the user selects a particular project from the ProjectType drop down box, a field called Project Codes in the subform should be populated with only project codes for that particular Project Type.

Can someone assist?

Thanks

 

[GaryPanic]

is the subform based on a new table or the same table as the main form ??

 

[rainman89]

create a query using the mainform information and after the selection run the query based on what is selected in the combobox

 

[essence]

It's based on another table

 

[GaryPanic]

use rainmans solution
after update do append into new table

g

 

[essence]

I will try it and give feedback