I have 2 forms that have quite a bit of data on them. On a form called "Move Stock", I am creating a stock transfer in another database without any issues, but after this transaction has been completed (It is a basic Insert SQL query that I am running), I need the form to requery the available stock quantities. On Form Load, the available quantities are displayed by running a select from an ODBC Linked view in SQL using form text box values as parameters.
I have tried executing
Expand|Select|Wrap|Line Numbers
- Me.Requery
Expand|Select|Wrap|Line Numbers
- Me.Refresh
Can someone please try and assist me?