Change subforms data from combo box

[oxicottin]

Hello, I have this form frmCategories and its subform frmCategoriesSubform and I am trying to change the data in the subform by changing what’s in the combo box cboDepartment on the frmCategories form. I also needed to be able to add a record to the results that come up for instance, if I selected metal shop then all the categories will show up that’s in the metal shop and if I wanted to add a category to metal shop I could using the last record in the list. What am I doing wrong?

 

[DCrake]

Take a look a the modied db. See Ho I have set up the Parent Child link between the main and sub forms.

I had to add the DepID field to the sub form.

 

[oxicottin]

Thanks David I didnt know you could do that thanks! If I try to add a record it wont let me, its like I have the categories txt box locked and it isnt. I need to be able to add a new category. If I made a selection and a list populated for that department how can I automaticly have the department filled in for the new record without the employee haveing to do it? Acually I wated to just hide the department and if I wanted to add a category I could judt type it in the new record and it would save it to whatever department I have selected. How can I acomplish this? Thanks!

 

[oxicottin]

Ok I figured out why I couldnt add to the categories. I also figured out my other issue and posted an update version so someone else can use it