>>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?

I removed all macro references to no avail. I recreated the whole form and the prob has disappeared. Sometimes a gremlin takes over despite good advice here, and thanks for help on this one.