On Sat, 10 Feb 2007 22:56:00 -0800, Jerry
well... the best result might be to properly normalize your database
so this doesn't need to happen... but...
Use VBA code in the control's AfterUpdate event. Is this a text field,
or a Yes/No field? Is the form control a Checkbox, Textbox, or Combo
John W. Vinson [MVP]