How to use setvalue to set form comboboxes to null

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.
 
M

ManningFan

Have you tried setting them to "=''" (there are 2 single quotes in
there)? Or "=' '"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to setvalue of comboboxes to null 1
drop down based on query but also need a blank as an option 4
Continuous Form or Datasheet Subform Setvalue 1
Can't set value of a list box to null 3
Help reqd. with the Macro "SetValue" property. 18
updating field to null 2
setvalue macro 4
Using SetValue in sub-form macro 5

Top