How to set to NULL????

[jboyle]

I have a form that allows the user to click on objects. When a given object is selected I store the selected object label name in a table. The label that is stored is used to filter the next form that is opened to that particular value. This all works fine but after I view that record, I would like to set the Label to NULL so I can view other records on the form if need be.
Thanks in advance - John

 

[ghudson]

Labels can not hold values. Are you changing the "caption" of the label and using that in your table?

Or are you really using text boxes and changing the value with code which is then stored in a table?

If you are really using text boxes and you want to set the value of the text box to Null, try this...

TextBoxNameHere = Null

I trust that you are also testing for Nulls in your routine? A Null value could cause a problem somewhere in your code.
If IsNull(TextBoxNameHere) or TextBoxNameHere = "" Then 'Do something!

HTH