Null values

[Eddie Mason]

Hi All,

I’m using values provided by a query in a parent form to provide captions in a sub form.

I’ve placed in the on load event of the sub form

Me.lblday1.caption = me.parent.day1
Me.lblday2.caption = me.parent.day2
Me.lblday3.caption = me.parent.day3
Me.lblday4.caption = me.parent.day4
………
Which works fine until I get a Null value in one of the parent fields.

I’ve tried adding a condition

If me.parent.day1 Is Null Then
Me.lblday1.caption = “-“
Else
Me.lblday1.caption = me.parent.day1
End if

But this still doesn’t work

Can anyone help with this?

Regards

Eddie

 

[a.sinatra]

NZ Function
________
Honda Ruckus

 

[Eddie Mason]

Great advice, thanks a lot.

Regards

Eddie