Dear experts,
I have a form with sub form. The theme is that the main warehouse has sub warehouses and each sub warehouse has its own products list. The detail is as follows,
Products receipt form with sub form.
1. ReceiptMain, 2. ReceiptSub.
Main form has sub warehouses combobox and sub form has products combobox.
I want to correlate the sub form combobox with the sub warehouses combobox in the main form.
I have made query on sub form productslist combobox.
ItemsListID, ItemsListName, warehousesId.
Criteria has been defined on WarehousesId as;
[Forms]![ReceiptMain]![warehousesId]
, and after update event on main form combobox has been defined.
Sub form combobox is showing items list as per the warehouses products list.
But the issue which i am facing is that after data entry when i change warehouse name it clears only products names not the others fields of quantity and so on. and on rechange to original warehouse it shows again products.
Kindly suggest the solution please.
when i change value in the main combobox the subform table shows the entries, i want to clear data related to that record, i don't know how to write code to clear the contents in the sub form.
I have a form with sub form. The theme is that the main warehouse has sub warehouses and each sub warehouse has its own products list. The detail is as follows,
Products receipt form with sub form.
1. ReceiptMain, 2. ReceiptSub.
Main form has sub warehouses combobox and sub form has products combobox.
I want to correlate the sub form combobox with the sub warehouses combobox in the main form.
I have made query on sub form productslist combobox.
ItemsListID, ItemsListName, warehousesId.
Criteria has been defined on WarehousesId as;
[Forms]![ReceiptMain]![warehousesId]
, and after update event on main form combobox has been defined.
Sub form combobox is showing items list as per the warehouses products list.
But the issue which i am facing is that after data entry when i change warehouse name it clears only products names not the others fields of quantity and so on. and on rechange to original warehouse it shows again products.
Kindly suggest the solution please.
when i change value in the main combobox the subform table shows the entries, i want to clear data related to that record, i don't know how to write code to clear the contents in the sub form.
Attachments
Last edited: