>>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.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."