<div>
try this in the current event of the form<br />
<br />
me.chkbox=(dcount(&quot;*&quot;,&quot;Oth<wbr />erTableNam<wbr />e&quot;,&quot;[jobN]<wbr />=&quot; &amp;&nbsp;me.JobN)&gt;0)
</div>


try this in the current event of the form

me.chkbox=(dcount("*","OtherTableName","[jobN]=" & me.JobN)>0)

<div>
Didn't work... here is yuor code with real names plugged in...<br />
<br />
Me.chkbxOPsked = (DCount(&quot;*&quot;, &quot;tblOutpurchase&quot;, &quot;[jobN]=&quot; &amp;&nbsp;Me.txtJobN) &gt;&nbsp;0)
</div>


Didn't work... here is yuor code with real names plugged in...

Me.chkbxOPsked = (DCount("*", "tblOutpurchase", "[jobN]=" & Me.txtJobN) > 0)

<div>
did you check if the current value Me.txtJobN exists in table tblOutpurchase
</div>


did you check if the current value Me.txtJobN exists in table tblOutpurchase

<div>
There is a record in tblOutpurchase that has a JobN value of 67 which is the key number of the JobN field in the main form.<br />

</div>


There is a record in tblOutpurchase that has a JobN value of 67 which is the key number of the JobN field in the main form.


<div>
where did you place the code?<br />
<br />
post here along with the other codes
</div>


where did you place the code?

post here along with the other codes

<div>
Hey, I just put the code in the onload event of the main form and IT WORKED! &nbsp;Now, one more question... <br />
<br />
On the same main form I have a 2nd checkbox. &nbsp;I want that checkbox to be checked if &quot;chkbxOPdone&quot; is true in the same 2nd table.<br />
<br />
??
</div>


Hey, I just put the code in the onload event of the main form and IT WORKED!  Now, one more question...

On the same main form I have a 2nd checkbox.  I want that checkbox to be checked if "chkbxOPdone" is true in the same 2nd table.

??

<div>
Perfect! &nbsp;Thank you very much!
</div>


<div>
<div class="content wysiwyg-content">
I have a form bound to a table that has a checkbox. &nbsp;I want this checkbox to be true if any record exists in an unrelated table. &nbsp;Both tables are &quot;related&quot; via a commonly named field named &quot;JobN&quot;. &nbsp;This field is a number field. &nbsp;How can I do this?
</div>
</div>


I have a form bound to a table that has a checkbox.  I want this checkbox to be true if any record exists in an unrelated table.  Both tables are "related" via a commonly named field named "JobN".  This field is a number field.  How can I do this?

Check a checkbox on main form if record exists in second 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.