here is what i want this to do:

2 subforms in a tab style

add entry only to the category in a fixed list. ( list is changeable from a different form.)

select the list by combo box. display in subform's (linked togethere by category as the key)

the attachment is what i have so far.
database.zip

i have not been able to get the combo box to list anything in any form i have tried multiple ways. im stuck and lost.