Main form to show a banner or a checkbox if continuous form contains a specific word (1 Viewer)

[theDBguy]

Thank you, it worked, this is what i did:

Private Sub Form_Current()

Me.medicaidcheckbox = DCount("*", "InsuranceList", "InsType Like '*Medicaid*' AND DrID=" & Nz(Me.DrID, 0)) > 0

If DCount("*", "InsuranceNotes", "InsuranceNotes <> null AND DrID=" & Nz(Me.DrID, 0)) > 0 Then
[InsuranceListsbfrm].Form![btnopeninsurancenotes].Visible = True
Else
[InsuranceListsbfrm].Form![btnopeninsurancenotes].Visible = False
End If

End Sub

Congratulations! I knew you could do it!