On current and On Change event

[reena]

Hi guys,

I have a form BDInfo. I have these two fields Current Exchange and Prior Exchange. Prior Exchange is dependant on current Exchange.

For eg:
if current Exchange in a record = "AMEX"
Then when a user changes a selection of Current Exchange in the record to "PHLX"
Now Prior Exchange = "AMEX"

I have the code to do above in the oncurrent event of form and change event of the combobox.
My question is, I need to warn the users when they make the selection from a combobox for the current exchange and by which prior exchange for that record will be automatically changed.

If they say OK allow them to change both.
If they say cancel not allow them to change anything.

I am struggling on these.
Thanks a million in advance.

reena

 

[Rich]

Look up help on the Dirty property
HTH