thanks very much for the clarification regarding OnClick - which makes logical sense now that you have pointed it out.
The Requery seems to work, but not fully.
Private Sub Form_GotFocus()
This is what i do:-
1. I click the Search Combobox and check the correct data is there.
2. I click a different control and change the data.
3. I stay on the same form and the same record
4. I click the Search Combobox again but the data is still the same
5. the data in the Search Combobox only changes if:-
a) I firstly click a different selection in the Search Combobox (eg. change record) and then on my next selection, the Search Combobox has updated.
b) I move forward one record and then back again
c) I close and open the form