G
golfinray
I have a form I use to look up projects for school districts. Each project
has a project number, like 0709-1104-001. Some districts have no projects. If
I open the form to a district with no projects, using my filter, the form is
blank. So I tried:
If IsNull(me.[project number])=true then
msgbox "that district has no projects, select another"
else
Me.filter = "[district name] = """ & me.combo & """"
Me.filteron = true
End If
End sub
It does not work and I've tried several things. What am I doing wrong?
Thanks, a bunch for your help.
has a project number, like 0709-1104-001. Some districts have no projects. If
I open the form to a district with no projects, using my filter, the form is
blank. So I tried:
If IsNull(me.[project number])=true then
msgbox "that district has no projects, select another"
else
Me.filter = "[district name] = """ & me.combo & """"
Me.filteron = true
End If
End sub
It does not work and I've tried several things. What am I doing wrong?
Thanks, a bunch for your help.