The main form(datasource: table1) and sub form are linked through an id.
The values in subform(datasource:table2) for the column- subcolumn2 should be based on main form column2(value selected by user) and a table5.
(Table5 has valid values of column2 and subcolumn2.
I should be able to see the previous values entered for subcolumn2 and also have the ability to enter new values. But the subcolumn2 should show legal values in drop down based on column2(main form) and table5.
I made the row source property of subcolumn2(combo box) to point to a query(select subcolumn2 from table5 where table5.column2 = forms!mainform!column2)
I get the correct values for subcolumn2 for the first record in main form but the drop down list doesn't change though I change column2 in mainform or advance to a different record unless I reopen the form
The values in subform(datasource:table2) for the column- subcolumn2 should be based on main form column2(value selected by user) and a table5.
(Table5 has valid values of column2 and subcolumn2.
I should be able to see the previous values entered for subcolumn2 and also have the ability to enter new values. But the subcolumn2 should show legal values in drop down based on column2(main form) and table5.
I made the row source property of subcolumn2(combo box) to point to a query(select subcolumn2 from table5 where table5.column2 = forms!mainform!column2)
I get the correct values for subcolumn2 for the first record in main form but the drop down list doesn't change though I change column2 in mainform or advance to a different record unless I reopen the form