Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

Form Data is not refreshing!

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
andybrooke
Asked:
andybrooke
  • 2
1 Solution
 
rockiroadsCommented:
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
 
andybrookeAuthor Commented:
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
 
rockiroadsCommented:
No worries :)

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now