<div>
How did you define the WhereCondition?<br />
<br />
In your Form or as a Variable?<br />
<br />
When you declare the Where condition like this:<br />
<br />
Dim WhereCondition As String<br />
<br />
WhereCondition = &quot;[FieldName]=&quot; &amp;&nbsp;Me.Fieldname2<br />
<br />
You can use this anywhere in the same Form.<br />
If you want to use this outside the Form as well, then declare a Public Variable.<br />
<br />
HTH,<br />
Daniel
</div>


How did you define the WhereCondition?

In your Form or as a Variable?

When you declare the Where condition like this:

Dim WhereCondition As String

WhereCondition = "[FieldName]=" & Me.Fieldname2

You can use this anywhere in the same Form.
If you want to use this outside the Form as well, then declare a Public Variable.

HTH,
Daniel

<div>
<div class="content wysiwyg-content">
DoCmd.OpenForm(FormName, View, FilterName, WhereCondition, DataMode, WindowMode, OpenArgs)<br />
<br />
the WhereCondition is working fine, but what I need to know is how to access the value of the WhereCondition once the form loads so I can use the value elsewhere<br />

</div>
</div>


DoCmd.OpenForm(FormName, View, FilterName, WhereCondition, DataMode, WindowMode, OpenArgs)

the WhereCondition is working fine, but what I need to know is how to access the value of the WhereCondition once the form loads so I can use the value elsewhere


How to get the value of WhereCondition from OpenForm

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

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.