Quick Question about query with no results

[Monroeski]

I have a form that is based on a query that pulls names according to an input ID. If the ID is invalid, the query obviously returns no results. If this is the case, I want to make an error message visible, but I can't figure out how to determine this in the VBA code. Basically, it looks something like this -

If Me.Name = Null Then
        Me.TextBox1.visible = false
        Me.TextBox22.visible = True
End If

Only Null doesn't work, nor does "", and I've even tried If Me.Name = False. I feel stupid for asking such a simple question, but this is stumping me. How do I determine if it is blank or not?

[puppydogbuddy]

I have a form that is based on a query that pulls names according to an input ID. If the ID is invalid, the query obviously returns no results. If this is the case, I want to make an error message visible, but I can't figure out how to determine this in the VBA code. Basically, it looks something like this -

If Me.Name = Null Then
        Me.TextBox1.visible = false
        Me.TextBox22.visible = True
End If

Only Null doesn't work, nor does "", and I've even tried If Me.Name = False. I feel stupid for asking such a simple question, but this is stumping me. How do I determine if it is blank or not?

Try this:

If IsNull(Me.Name) Then
        Me.TextBox1.visible = false
        Me.TextBox22.visible = True
End If

[Monroeski]

That worked, thanks for the help.