How to use setvalue to set form comboboxes to null

  • Thread starter Thread starter tbmarlie
  • Start date Start date
T

tbmarlie

I've put a command button on my form which runs a macro that is
trying
to basically refresh all of the comboboxes (and one text box) to
null. I'm doing this by using the setvalue action in the macro for
each of the comboboxes, then putting in the item (eg. [Forms]!
[frm_Main]![Cbo_State]) and then setting the expression to "=Null",
but, of course, it is not setting the items to null. Can someone
please let me know what I'm doing wrong. Thanks.
 
Have you tried setting them to "=''" (there are 2 single quotes in
there)? Or "=' '"?
 
Back
Top