This syntax works as it should if the listbox has focus. However, if the listbox has been tabbed out of, or another control clicked this syntax always shows the listbox is null. How can I capture the selected value from the listbox even if the user has clicekd out of it?
Code:If IsNull(Me!List10)Then MsgBox "Please Select A Value!", vbOKOnly Me.List10.SetFocus ExitSub Else selectedoption =Me!List10 EndIf