I have one unbound combobox with row source query to filter another bound combobox. Its name of program and based on that i get modules of that program (their id) in table with school class.
I can make it update unbound to bound in new record, but, when i navigate record it doesn't not update unbound.
Is there a way to do that? or may i display that information in another user friendly way (please make suggestion)?

If it is unbound then you will have to requery the combobox each time by using Combobox_Name.Requery or Combobox_Name.RowSource = "Select [stuff],[things] From [some table]" or Combobox_name.Rowsource = SomeQueryName at whatever trigger you want (ie. On Click, After Update)

Hope that helps.

I tried and it didn't work. probably done something wrong because unbounded never pull bounded value. (unbonded - one to many bounded).

But, now i made in table new field so i have two bounded field. They are related, so having modules and program field (one program have many modules) isn't necessary, but combo box work like expected. On record navigation show right value and on change they behave like it should.

Is there any negative side of story in storing 2 related informations in contract table?