<div>
A great reference link for MS Access coding. &nbsp;I downloaded a document which listed by example many ways to code between a form and subform
</div>


A great reference link for MS Access coding.  I downloaded a document which listed by example many ways to code between a form and subform

<div>
<div class="content wysiwyg-content">
I have a listbox on a subform and i need to from a subform access a value in a texbox on the main form and update the subform's listbox recordsource to have it repopulate from a query driven off of the changed value from the main form.<br />
<br />
In a nutshell how can I programmatically access the controls between a form and a subform so that I can change some other display of data with some new criteria. &nbsp;The use of exclaimation marks and the word Form that seems to need to be peppered is not that clear.<br />
<br />
Any and all help on this would be greatly appreciated.<br />
<br />

</div>
</div>


I have a listbox on a subform and i need to from a subform access a value in a texbox on the main form and update the subform's listbox recordsource to have it repopulate from a query driven off of the changed value from the main form.

In a nutshell how can I programmatically access the controls between a form and a subform so that I can change some other display of data with some new criteria.  The use of exclaimation marks and the word Form that seems to need to be peppered is not that clear.

Any and all help on this would be greatly appreciated.



MS Access Forms and Sub Forms

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

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.