<p>Have a VERY simple form with a dropdown list on it.</p><p>1&gt; Add process works great...not a problem.</p><p>2&gt; Edit process works great as far as storing the selected or entered data.</p><p>3&gt; On entering the Edit mode, the dropdown does not select the value in the list corresponding to the value stored in the database - yes...I am storing values not text and I have confirmed.</p><p>4&gt;Did find a old post about an issue with XMOD not liking fixed character value fields &nbsp;and converted the database to use varchar instead. &nbsp;That fixed the problem in the simple test form created with form creator and I thought I was fine....BUT...</p><p>5&gt; I found that if the edit process uses a stored procedure to UPDATE the database, the value is stored correctly in the database...but if you edit the record again, the dropdown list is broken. Replacing the SP with a submit command ="Update, etc" fixes the problem and the DDL works as it should.</p><p>I much prefer to work my database adds, edits, and deletes via SP where I have much more control. &nbsp;This is VERY strange behavior and these are just my preliminary findings...</p><p>Anyone?&nbsp;</p>