<div>
Hi Rockiroads. &nbsp;Sorry yes it is access, I only noted that after i submited and could not work out how to edit. &nbsp; Thank you for your answer, IT WORKED
</div>


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

<div>
No worries :)<br />
<br />
I think you can click on Request Attention to sort out moving to another area.
</div>


No worries :)

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

<div>
<div class="content wysiwyg-content">
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.<br />
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.
</div>
</div>


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.

Form Data is not refreshing!

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

HTML (HyperText Markup Language) is the main markup language for creating web pages and other information to be displayed in a web browser, providing both the structure and content for what is sent from a web server through the use of tags. The current implementation of the HTML specification is HTML5.