Hi Bob,
thanks for your help with this.
I am, indeed, putting my code in the controls property sheet, not the form code module - I want the second listbox to update only when the first listbox is changed, not when anything else on the form happens - clearly, I haven't really understood how...