Update form drop down retain initial value

Can you please help me with the attached menus. Both update forms. 1 dynamic menu, 1 static menu. The menus need to retain the initially selected values. Thank You,

select the menu in design view, then go to the property inspector and click the Dynamic button. For the Select Value equal to option, click the lightning bolt icon and select the corresponding column from the main recordset for the update page.

It is working with a static menu of choices and dynamic existing record from database but NOT on the attached dynamic menu page. It will retain the initially selected value however if you select a new value it enters 0 into the database for the GalId.

the problem is case sensitivity.

the update behavior is expecting a form element named "GalID", but your select list is named "GalId" (lower case d):

change:

<select name="GalId" id="GalId">

to:

<select name="GalID" id="GalID">