Hi Neil,

PMJI.

> The maximum possible value for Reccount('temp') will be 1 ALWAYS.

If this is the case why bother with the temp.dbf at all - just select from the main table for the single listbox item.

Presumably there are no deleted records in the archived table? If this is the case it may help to make sure DELETE is set OFF when the query runs.

HTH,
Viv