I have an order form where we enter product details & quantities. Within the screen is a subform showing current stock levels.
How can I get the subform to update stocks after every order entry?
I have tried 'requery' but must be doing something wrong.