How to auto clear values in ComboBox back to default

[dejanc]

Hey,

I have ComboBox with two values, "Blank" and "Yes". If I set some records with value Yes, after that I would like to clear it for all records back to Blank value, default value. Of course would like to be done with Comand Button.

I was looking solutions, but...

Thanks to anyone in advance for help!

 

[dcb]

Is this your bound column? if so then a button with the code

Me.comboBoxName = "blank"

 

[boblarson]

Is this your bound column? if so then a button with the code

Me.comboBoxName = "blank"

Actually it would be

Me.comboBoxName = ""

or

Me.comboBoxName = Null

and as noted it has to be a bound combo or else it will change for all records (if unbound and in datasheet or continuous form).

 

[dcb]

Actually it would be

Me.comboBoxName = ""

or

Me.comboBoxName = Null

and as noted it has to be a bound combo or else it will change for all records (if unbound and in datasheet or continuous form).

I read

I have ComboBox with two values, "Blank" and "Yes"

as actual values because of the quotes..... -dejanc please advise

 

[boblarson]

I read as actual values because of the quotes..... -dejanc please advise

Ah, yeah that would be logical

 

[dejanc]

well I`m not an expert, but...I have this field to mark a record with blank or Yes. And I have also a query, which is exporting a records with value Yes to .XLS .
So, I would like, after exporting, set back that every record would be blank...

 

[dcb]

Ah ok - the blank/yes is in a table?? - then you need to do an update query after your export

Update TABLE_NAME set BLANK_YES_FIELD_NAME = "Blank"

 

[dejanc]

Yeah, that is the best option. Thanks Dcb, and of course other helpers to...

 

[dcb]

Yeah, that is the best option. Thanks Dcb, and of course other helpers to...

Glad to be of help