>Tried the two syntax lines below to achieve my desired results. It works when I step thru with the Debugger, but not when I run it live.
>
>The control is a drop-down combo box, that gets its values from an array. The control is bound to the "MerchType" field in the "Merchant" table, and the code is in the InteractiveChange event.
>
>Anyone know why this code isn't firing?
>
>=============
>IF GETFLDSTATE("MerchType","Merchant") = 2
>
>IF OLDVAL(MerchType,"Merchant") <> ComboBox.Value
>=============
>
>DP

David,

Try placing quotes around the MerchType in the OldVal statement.

IF OLDVAL("MerchType", "Merchant") ...


Beyond that, what code is not firing? Both of the lines or only the OLDVAL or is the OLDVAL firing but not returning what you are expecting?

Todd