I have a table control that contains a column that is a combo box that stores its values as integers. I have a macro that runs every time the form containing the table control is loaded or changes records that sets the combo box to a default value for the purpose of saving the user the time of selecting it. Unfortunately, the visible value for the default does not show up, and it can be manually selected, but when the record is submitted, there’s an error because that combo box field has been cleared of its value.
Edit: Per Ratslinger’s recommendation, I’m attaching the .odb file. It connects to a mySQL backend. Hopefully the fact that you won’t have access to the backend won’t inhibit determination of the problem’s source.Metrology.odb