- Re: Formula for On Click field to change the value manually by typing that is display from a reference table. I like Alain's suggestion best. It replaces the Choice field with a n:1 reference field, which acts similar to a pop-up with an unlimited number of items. Plus it requires less code. Thank you Alain.