>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?
If it's not broken, fix it until it is.
My Blog 
