<div>
<div class="content wysiwyg-content">
I have a form that has a sub-form. &nbsp;The sub-form is a datasheet view form and contains a Yes/No checkbox named chkbxBilled. &nbsp;If all of the records in the datasheet sub-form are checked then I do not want that parent record to display in the combobox.<br />
<br />
How can I do this?
</div>
</div>


I have a form that has a sub-form.  The sub-form is a datasheet view form and contains a Yes/No checkbox named chkbxBilled.  If all of the records in the datasheet sub-form are checked then I do not want that parent record to display in the combobox.

How can I do this?

Filter records shown in a combobox on a main 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.