Determine if combo box values changed

[dbero]

I have an unbound form that contains combo boxes, command buttons and charts. the command buttons are to requery data based on criteria in the combo boxes.

What I am trying to do is to determine if a change has occurred to a combo box when the command button is clicked. if the combo box values are the same, I do not need to refresh the charts as part of the routine. if the combo boxes were changed, then i do.

So, is it possible to determine in a command click routine if the unbound combo boxes have changed values?

thank you

 

[PWise]

comboboxoldvalue=me.combobox
requery

if comboboxoldvalue<>me.combobox then
refresh the charts

end if