If there is one field that is a COMBO BOX and the second field is dependent on the selection made in the first field, we manage that. We don’t manage on a subform. As you know on the main form, i.e. sales invoice there may be one record connected to multiple records in the subform. On the images attached it can be seen that “Ledger Acc Name” control what you may find in “Sub Ldg Acc Name”. Our current setup result when we select one of 19 Ledger Accounts, i.e. Vehicles it brings up a list of vehicles in “Sub Ldg Acc Name” as it should. In the second line if we select “Furniture” it correctly brings up a list of furniture but as you can see in the second image then the choice disappears. I understand why but don’t know what to do to fix it.
I have tried all kinds of things in the row source for “Sub Ldg Acc Name” but fall short on the way to do it.