Refresh/Requery ODBC linked queries on forms

[DoubleD]

Hi. Hope someone can help me. First off, I am not a developer and everything I know about VBA I taught myself.

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

Me.Requery

and

Me.Refresh

and the same on the actual controls, but the available quantities still stay exactly the same.

Can someone please try and assist me?

[Seth Schrock]

The first thing that I would do is to make sure that your changes have been saved. Try going straight to your backend and run your query and see if it has the data changes.

[DoubleD]

Hi Seth. The changes are definitely saved. I can see the data that was inserted to the database.

[Seth Schrock]

You say that you are getting your values from a SELECT statement being run in your Load event. Try running that same code as a replacement for you Me.Requery.