Still having trouble with lblSeeNotes

[wwiSports]

I have two forms, one is the "Orders" form and the other is the "Notes" form. I have put a lable called lblSeeNotes on the Orders form and set it's visible property to No. I have also put a text box called "Notes1" that is based on the notes form and set it's visible property to no. I have put in the Form_Load code the following code:

If Me.Notes1 Is Null Then
Me.lblSeeNotes.Visible = False
Else
Me.lblSeeNotes.Visible = True
End If

Now I get a message saying "Object not found" and highlighting the "If Me.Notes1 Is Null Then" section of the code above. I am assuming that this is because it's visible property is set to no.

Both of the above forms are totally unbound, and everything is done by vba. Both forms also refer to the "Athlete" table.

Can someone help me fix my code???

My utltimate goal is to have this label ****SEE NOTES**** appear if the notes field has something in it.

Beth

 

[Malchik]

hi,

try:
if isnull(Me.Notes1) Then
Me.lblSeeNotes.Visible = False
Else
Me.lblSeeNotes.Visible = True
End If

Mal'chik

 

[Malchik]

hi again,

you can do that in one line if you prefer:

Me.lblSeeNotes.visible = not isnull(me.notes1)

Mal'chik

 

[wwiSports]

I got it fixed!!! Thanks!

Beth