I created a main form with a sub form. In the main form, I have two combo boxes i.e. combo1 and combo0. combo1 value controls the drop down list in combo0. So far what I have done works perfectly fine as what is selected in combo0 displays the correct field information in the main form and the sub form. The storeid links sub form to the main form.
In combo1, I set "grocery" as the default storetype and in combo0, I have set 127 as the default storeid, so that when I open the main form, 127 storeid is alredy preselected. However, on open, the sub form does not display the record of storeid #127. It displays storeid #1 everytime the main form is opened. How to make them sync? I want to be able to see the record of storeid #127 display on open.
Thanks in advance.