Refreshing Data

[Pure Salt]

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.

[burrina]

You can try this.

Forms!YourFormNameHere.Requery

HTH

[RuralGuy]

Try: YourSubFormControlName.FORM.Requery