Solved

Form Data is not refreshing!

Posted on 2009-04-09
3
193 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
  • 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Join & Write a Comment

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now