Command bar combo box will not clear

[arage]

Command bar combo box will not clear
When I select an item from my command bar combo box I designed, I cannot then delete the value in that combo box and set it’s value to null, it will repeatedly save the last value that was in it. Could someone tell me why this could be happening?

 

[boblarson]

arage:

How are you trying to clear it?

 

[arage]

Well basically my menu bar has grouping based on the logon user…coordinator, manager, director and other user. Now whenever the first three groups try to access a report, the report(s) will open as will the command bar I am having difficulty with. This command bar will allow the report to be filtered further if the user wishes. Now If group OTHER USER logs on, they cannot have the report open initially & then have the option to use the command bar to filter further because for this particular group it is necessary to capture the filter data required to open the report before it is run ie the command bar has to run first, criteria selected and then the report is run. But since I’m not creating & deleting the command bar each time it runs, it seems to be retaining the value I place in a combo called REGION but other similar combos don’t behave like that, they revert back to NULL, this happens if I exit the database & reopen it, otherwise all the combos will retain the last value entered. I hope this makes sense to you.

 

[boblarson]

Your explanation is somewhat helpful to me, but I was hoping to see what code you were using to make the combo boxes revert to their starting values.

I think that you would want to find the event that would be the one you want to cause the combo box values to revert to the values when the form opened and then run "requery" to accomplish this.

I don't know if that helps much, but I hope so.