I have an issue with refresh data in the main form/Subform section. The database is huge and in split form (FE and BE) hence sharing screenshots and not DB
1. The form in question is of Invoice entry - Main form and sub form. The issue pertains to the main form
2. I capture the consignee code in the main form from thru a cbo box where source data is from a query built for the Pending orders. Therefore codes which have pending orders are ONLY displayed
3. There is table where we have information of consignee code and container no. We need to capture container no in a cbo box using the information from the container table. Validation is that the consignee code should be same as selected in the form and the container no should be in transit (to limit the items in the cbo)
4. The validation of the container no cbo works when form is opened. However while the Invoice form is open and we change values in the container table, the cbo values are not refreshed! If I close the invoice form and reopen, the cbo values are refreshed!
5. If I use Refresh all from ribbon, command shifts to record no 1 which is not convenient!
What do I do?
1. The form in question is of Invoice entry - Main form and sub form. The issue pertains to the main form
2. I capture the consignee code in the main form from thru a cbo box where source data is from a query built for the Pending orders. Therefore codes which have pending orders are ONLY displayed
3. There is table where we have information of consignee code and container no. We need to capture container no in a cbo box using the information from the container table. Validation is that the consignee code should be same as selected in the form and the container no should be in transit (to limit the items in the cbo)
4. The validation of the container no cbo works when form is opened. However while the Invoice form is open and we change values in the container table, the cbo values are not refreshed! If I close the invoice form and reopen, the cbo values are refreshed!
5. If I use Refresh all from ribbon, command shifts to record no 1 which is not convenient!
What do I do?