Hi, thanks for your reply. Excuse my ignorance, how do you wish me to show you the table? And second yes the query sorts to the order I want, but the combo box still shows in a random order. I've then deleted the combo box and reinserted a new one and then the form doesn't show the...