<div>
Most times you don't want a hard-coded value so here is a better example:<br />
<br />
SQLtext = &quot;update Contracts set SelectedPrint= 'Yes' where Account= '&quot; &amp;&nbsp;Me.txtAccount &amp;&nbsp;&quot;'&quot;<br />
<br />
Or, if SelectedPrint is a Yes/No data type then:<br />
<br />
SQLtext = &quot;update Contracts set SelectedPrint= True where Account= '&quot; &amp;&nbsp;Me.txtAccount &amp;&nbsp;&quot;'&quot;
</div>


Most times you don't want a hard-coded value so here is a better example:

SQLtext = "update Contracts set SelectedPrint= 'Yes' where Account= '" & Me.txtAccount & "'"

Or, if SelectedPrint is a Yes/No data type then:

SQLtext = "update Contracts set SelectedPrint= True where Account= '" & Me.txtAccount & "'"

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
OnClick I'd like to open a form, filter by a field, and with ONLY the filtered records I'd like to update a Yes/No field in a table.<br />
<br />
I've done the easiest bit, but also I'd like to update a field called 'SelectedPrint' in my 'Contacts' table with 'Yes' for every record filtered 'KI1100'<br />
<br />

<pre><code id="code-10-28973537-1">DoCmd.OpenForm &quot;InvoiceEmail&quot;
DoCmd.ApplyFilter , &quot;Account = 'KI1100'&quot;</code></pre>
<br />
Can anyone help?<br />
<br />
Thanks,
</div>
</div>


Hi,

OnClick I'd like to open a form, filter by a field, and with ONLY the filtered records I'd like to update a Yes/No field in a table.

I've done the easiest bit, but also I'd like to update a field called 'SelectedPrint' in my 'Contacts' table with 'Yes' for every record filtered 'KI1100'

(CODE)

Can anyone help?

Thanks,

Open Form - Filter Field - Update Another Field in Table

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.