[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Form Data is not refreshing!

Posted on 2009-04-09
3
Medium Priority
?
235 Views
Last Modified: 2013-11-28
Hi. I have a form with a subform in it. I have a Append query which works fine. It just adds selected records to another table that is linked to the sub form above.
All this works fine except whn you run the query in order for the new added records to display you have to close the open form and reopen it. I have tried adding in the VBA code to refresh etc but nothing seems to work.
0
Comment
Question by:andybrooke
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 2000 total points
ID: 24105953
Is this in Access or HTML? I ask becaus it is posted in HTML but sounds like you are working on Access forms.

Refresh will update current set
Requery will repopulate the form's recordset based on the query

If access forms, try issing a requery on the form (eg in Access vba it is Me.Requery)
0
 

Author Closing Comment

by:andybrooke
ID: 31568456
Hi Rockiroads.  Sorry yes it is access, I only noted that after i submited and could not work out how to edit.   Thank you for your answer, IT WORKED
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 24106064
No worries :)

I think you can click on Request Attention to sort out moving to another area.
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question