I have a database GUI that I am building for order entry. There are 3 main screens.
Customer SWX: F(x) >> Search for customers, create customers, view their details, and start an order.
Order SWX: F(x) >> List the order history of the customer that was selected, create a new order, edit an order, or remove an order.
Create Order: F(x) >> Select the items to be ordered, the quantity, and save to the order table.
All of that works fine. But what I want is the ability to finalize the order. This will sum the order total and save the total in my order table. That works too. However, I cannot get it to update the Order SWX list box of orders by the selected customers.
I am loading the rowsource via VBA, not a Table/Query within the form. How do I requery that listbox on the Order SWX screen from the Create Order screen?