<div>
Perfect. &nbsp;I've never seen...<br />
<br />
Form_ &nbsp; &nbsp;(underscore)<br />
<br />
before.
</div>


Perfect.  I've never seen...

Form_    (underscore)

before.

<div>
<div class="content wysiwyg-content">
I have a sub form that has a combobox. &nbsp;After the combobox has been updated am update query runs which adds records to the record source. &nbsp;But after that happens I want the subform to be refreshed to show all of the records including the ones added via the query.<br />
<br />
I'm not sure how to make the subform refresh.<br />
<br />
Please note that there is a main form with a subform. &nbsp;The subform I'm trying to refresh is a sub-form on the sub-form that is in the main form.<br />
<br />
After the query runs in the VBA code I tried the following but it doesn't work:<br />
<br />
Forms!frmJobSetup!subfrmUn<wbr />its.Form!s<wbr />ubfrmLineI<wbr />tems.Form!<wbr />subfrmLine<wbr />Items.Refr<wbr />esh
</div>
</div>


I have a sub form that has a combobox.  After the combobox has been updated am update query runs which adds records to the record source.  But after that happens I want the subform to be refreshed to show all of the records including the ones added via the query.

I'm not sure how to make the subform refresh.

Please note that there is a main form with a subform.  The subform I'm trying to refresh is a sub-form on the sub-form that is in the main form.

After the query runs in the VBA code I tried the following but it doesn't work:

Forms!frmJobSetup!subfrmUnits.Form!subfrmLineItems.Form!subfrmLineItems.Refresh

How refresh sub-form after update via a combobox?

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

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.