<div>
Adjust the MasterLinkFields and ChildLinkFields to hold the value to filter by and the field to filter on, respectively.
</div>


<div>
It solely depends on your use-case and what the form/subform represents and whether the main form is data bound or not and when, where and how the filter criteria is determined.<br />
<br />
Possible approaches:<br />
- use the master/child approach as Gustav wrote<br />
- use a [Form]!.. reference in the data source of the subform<br />
- use TempVars<br />
- use proxy function(s) to return the filter values in the subform<br />
- change the data source of the subform
</div>


Developer

Murray Brown

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
What Access VBA would I use to open a &nbsp;form and at the same time filter the sub form in &nbsp;it?<br />
&nbsp; <br />
Thanks
</div>
</div>


Hi

What Access VBA would I use to open a  form and at the same time filter the sub form in  it?
  
Thanks

Access VBA open form and filter sub form in it

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.