<div>
If the function is public, you can all it like this:<br />
<br />
&nbsp; Call Me!NameOfSubformControl.Fo<wbr />rm.FCDB()<br />
<br />
/gustav
</div>


If the function is public, you can all it like this:

  Call Me!NameOfSubformControl.Form.FCDB()

/gustav

<div>
Is there some particular reason that you are working with unbound forms?<br />
<br />
If the subform were bound, it's Recordsource query could reference a control on the mainform to get selection criteria:<br />
<br />
WHERE somefield = Forms!MyForm!somefield<br />
<br />
Then in the click event of the button, you would requery the subform.<br />
<br />
Me.sfrmName.Requery
</div>


Is there some particular reason that you are working with unbound forms?

If the subform were bound, it's Recordsource query could reference a control on the mainform to get selection criteria:

WHERE somefield = Forms!MyForm!somefield

Then in the click event of the button, you would requery the subform.

Me.sfrmName.Requery

<div>
<div class="content wysiwyg-content">
The main form has a button to find a record. &nbsp;I have a subform on the main form that has vba code to open a recordset and show a list of records. &nbsp;I would like that to happen when I click on the button on the main form.<br />
<br />
I just need the code to be able to reference the vba in the subform from the main form so it will run.<br />
<br />
Main form name: frmMain<br />
Subform name: frmFCDBHeader<br />
<br />
The code that needs to be called n the subform is: Public Sub FCDB()<br />
<br />
Thanks,<br />
Scott
</div>
</div>


The main form has a button to find a record.  I have a subform on the main form that has vba code to open a recordset and show a list of records.  I would like that to happen when I click on the button on the main form.

I just need the code to be able to reference the vba in the subform from the main form so it will run.

Main form name: frmMain
Subform name: frmFCDBHeader

The code that needs to be called n the subform is: Public Sub FCDB()

Thanks,
Scott

I need to run vba code in a subform from the main form

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.