By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,466 Members | 1,132 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,466 IT Pros & Developers. It's quick & easy.

Refresh/Requery ODBC linked queries on forms

P: 24
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
Expand|Select|Wrap|Line Numbers
  1. Me.Requery
and
Expand|Select|Wrap|Line Numbers
  1. 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?
Jun 12 '15 #1

✓ answered by 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.

Share this Question
Share on Google+
3 Replies


Seth Schrock
Expert 2.5K+
P: 2,951
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.
Jun 12 '15 #2

P: 24
Hi Seth. The changes are definitely saved. I can see the data that was inserted to the database.
Jun 12 '15 #3

Seth Schrock
Expert 2.5K+
P: 2,951
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.
Jun 12 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.