>>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