Solved

Form Data is not refreshing!

Posted on 2009-04-09
3
228 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 500 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

739 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