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

Added records not shown in my existing query

P: 97
I have added more records to my table, but one of my forms or queries is not reflecting this change. However, those records are shown in a query that I created after adding them to the table. Does this mean that I have to create a new form and query each time I add some records? Can anybody help me on why and what is causing this problem? Thanks!
Apr 30 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 2,545
Hi loisk. I think you may well have to requery the current form in order for it to show the most up-to-date data including any new records. An excerpt from the Access Help entry for Refresh or requery data is shown below.

Refresh or requery data
If you are using a Microsoft Access project or a Microsoft Access database that's shared on a network, other users could be changing data while you are viewing the same data in a datasheet or form. Microsoft Access updates the data you see at regular intervals. However, you can immediately display the most current data by refreshing the records.
In an Access database (.mdb), refreshing records only updates the data that already exists in your datasheet or form. It doesn't reorder records, display new records, or remove deleted records and records that no longer meet specified criteria. To perform those tasks, requery the records.
May 1 '08 #2

Post your reply

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