422,363 Members | 2,348 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,363 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.
1 Week Ago #1
Share this Question
Share on Google+
3 Replies


100+
P: 116
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?
1 Week Ago #2

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

NeoPa
Expert Mod 15k+
P: 30,631
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.
5 Days Ago #4

Post your reply

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