A simple form with a combo box. The RowSource is a table of salutations. My OnOpen code is wanting to pre-populate the combo pane with the currently known value, thus:
In Debug, I can see that Me.cboSalutation does in fact have the string value returned by the DLookup, but it DOES NOT display in the combo's pane when the form is displayed. What might I be missing here?Code:Me.cboSalutation = DLookup("Salutation", "tblSalutations", "SalID = " & !SalID)
Maybe this will help: