How to setvalue of 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.
 
K

Ken Snell

What you describe should work. Are the combo boxes bound to a field in the
form's recordset? Or are they unbound? Is the LimitToList property set to
Yes or No?
 

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 use setvalue to set form comboboxes to null 1
drop down based on query but also need a blank as an option 4
Using SetValue in sub-form macro 5
SetValue and CurrentUser() 2
setvalue action changes record focus 5
setting the argument in SETVALUE Action of macro 6
setvalue question 2
'SetValue macro action' problem 4

Top