>This is becasue the user can add a record and the listbox needs to be updated to reflect this.
>I've taken it out to experiment but made no diff.

Can you set your listbox RowSource to be a cursor instead of a select statement? Just select records into the cursor, then set listbox recordsource.

How you're adding records to the source of the listbox?