Continuous Forms & Logical Tests

[Luddite Lad]

I have a continuous form, that displays in the body the results of a number of selections from a previous form.

In the header I have a message that I want to either shown or hide depending on the result of the following code in the "On Current” event;

Private Sub Form_Current()

If Text29.Value = 0 Then
Label32.Visible = False

End If

End Sub

The default form Label32 is for it to be visible. Text29 is unbound and derives it's value from "=Min([WareHouseID])-Max([warehouseid])" no problem there.

The problem is that test does not perform as I expect it to. I have tried all sort of combinations and permutations but can not get it to respond correctly. It seems to think that Text29.Value is equal to zero regardless of the result it is showing

I'm guessing that there is something about continuous forms I have not yet learned

 

[Luddite Lad]

.....or is it because the form is based on a select query?

 

[Luddite Lad]

Thanks Pat that's done the trick. I honestly thought that I had tried that before I'd posted the question, but it must have been one of the combinations I didn't try