I have a combo box for selecting records - Employee Name.
The only macro I have is After Update - SearchForRecord where condition ="[Employee Name] = " & "'" & [Screen].[ActiveControl] & "'". The thing is that the content of the comobo box stays there after selection. It is ok when I use the combo box to pick a name because it matches the details below but if I use arrows or add a new record then the name displayed in the combo box if wrong. How to make it disappear after selection?
I realise these are probably basics...