473,396 Members | 1,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Refresh Table

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
3 3897
BikeToWork
124 100+
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
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
NeoPa
32,556 Expert Mod 16PB
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

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

Similar topics

6
by: Bruce | last post by:
I want to create a new table based on an existing table, but I don't want the tables to have any enforced relationship. Is this possible without having to do a CREATE TABLE and an INSERT? ...
9
by: Andrea | last post by:
Hi, I've read the former postings but was not able to solve my problem: I have a Summary Table (or MQT as you like it) and the query optimizer does not seem to use the summary table. I run...
7
by: Zri Man | last post by:
I have searched far and wide (not wide enough some might chip in) but cannot find the syntax for creating a staging table for an MQT. IBM manuals talk long and longer in serveral sections of this...
6
by: Klemens | last post by:
I want to create an MQT, intialize it manually and then use staging table to refresh it with new data, but i don' t see a way for not doing full refresh after creating the staging table. I tried...
7
by: Lisa | last post by:
I have an Access 2000 application that uses the following function to re-link my tables when I switch from my Current back end to a Dummy back end. I also use it to refresh my links. Function...
0
by: cwahlmeier | last post by:
We are unable to create a new summary table while a REFRESH TABLE command is running on different summary table. Why does the REFRESH TABLE command hold a lock on SYSTABLES? Is there a...
2
by: Memborg | last post by:
Hej Everybody I have tried do make an "instant search" in javascript, ie everytime one hits a key the javascript sends the request to a database and returns the result into a table. The...
3
by: BD | last post by:
I'm doing some cross-platform development, under LUW 8.2 (Windows) for z/OS 8. I have some fairly complex queries which address some rather large tables. One query takes approximately 30...
2
sandyinfinite
by: sandyinfinite | last post by:
Hi I make entry form to enter data. That data is go to table to make Chart. My question is that how to refresh that table data? I have use but wont work... table1.Refresh
1
KhadkaSaroj
by: KhadkaSaroj | last post by:
Hi there! I have a Form having comboboxes and labels which show the corresponding records of a Table. The Form is meant to delete records of Table but when a record is deleted I can see #DELETED...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.