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

Refresh Table

P: 6
I have a table that is receiving updates from a form via an append query. I need the table receiving the updates to refresh and display the recently added record as soon as it is added. Currently, the only way that I am able to see the new record is by navigating to the table and saving the table. I have tried several variations of Do.Cmd to include "requery, repaint, and refresh" however the underlying issue seems to be that all of these are by default acting on the "current object" which is not in this case the table that I need updated. Do I need to shift focus to the table needing the update and then run Do.Cmd Requery? If so, how do I shift focus with out interrupting the user's view of their form view which is the only view users will be using in the project. Thanks in advance for any assistance here.
Apr 17 '18 #1
Share this Question
Share on Google+
3 Replies

P: 124
Assuming the form's recordsource is based on that table, me.requery should refresh the data. Is the form unbound or bound to another table?
Apr 17 '18 #2

P: 6
Sorry, minor detail I left out, it's unbound which is why I assume it's not updating with me.requery
Apr 17 '18 #3

Expert Mod 15k+
P: 31,409
Certainly if it's unbound it won't be affected by any Requery or Refresh.

To help further (if required now) we'd need a much clearer understanding of what's where and connected to what. I have no idea what you mean by referring to the table - other than the one point I think we can be sure of, which is that it isn't the table itself. They don't need requerying and can't have unbound items in them.
Apr 20 '18 #4

Post your reply

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