Can I make a Combo Box show Last Item Chosen?

[fishey]

Is there a way to make the "default entry" in a Combo Box display the last item chosen from the Combo Box when it was last used?

 

[glalsop]

Maybe try using a global variable:

In a code module:
Public myLoadValue as String

Behind the form:
Private Sub Combo2_Change()
myLoadValue = Me.Combo2.Value
End Sub

Private Sub Form_Current()
Me.Combo2.Value = myLoadValue
End Sub

Private Sub Form_Load()
Me.Combo2.Value = myLoadValue
End Sub

Try something like that.




-Gary