>>>Yes, that works now. Thanks! Now, since I don't have a controlsource, do you recommend that I put code in the interactiveChange event to record the change? Such as:
>>>replace
with this.displayvalue
>>>Or maybe that should go in the valid event since the user could be typing in a new value.
>>>
>>InteractiveChange is better than Valid, but if you have Save button and this is the only place where you actually save a record, you could put this code over there.
>
>Ross (and Edward), I've found that using an array instead of a table as the RecordSourceType (simply do a SQL select of your small table to an array) solves the problem. Why an array works one way and a table another is a mystery, but I always use arrays if the user is allowed to enter his own values.
>
>HTH
>Barbara
Maybe yes, but table will work Ok as well.
Edward Pikman
Independent Consultant