<div>
<div class="content wysiwyg-content">
hello, 
 
I want to build a SQL that will check the table based on a &quot;permit #&quot; then if within that it finds that 4 fields are -1 then deny using that permit# 
 
OK, so on my form I have the field: &nbsp;txtPermit 
 
on the beforeupdate, or even the afterUpdate, &nbsp;I want it to search the txtPermit field in a table: &nbsp;tblHWWPass, pull 4 fields and check to see if those all have &quot;-1&quot; (they are checkboxes) 
 
txtPermit: &nbsp;1 
 
my sql will be 
 
(&quot;Permit&quot;, &quot;tblHWWPass&quot;, me.txtPermit) 
 
but I don't know how to see if 
Tab1 
Tab2 
Tab3 
Tab4 
 
are all -1 
 
?
</div>
</div>

hello,

I want to build a SQL that will check the table based on a "permit #" then if within that it finds that 4 fields are -1 then deny using that permit#

OK, so on my form I have the field:  txtPermit

on the beforeupdate, or even the afterUpdate,  I want it to search the txtPermit field in a table:  tblHWWPass, pull 4 fields and check to see if those all have "-1" (they are checkboxes)

txtPermit:  1

my sql will be 

("Permit", "tblHWWPass", me.txtPermit)

but I don't know how to see if 
Tab1
Tab2
Tab3
Tab4

are all -1

?

Get a value from Table, check if fields are -1

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.

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.