I use the LOOKUP function quite a lot in the REFRESH event of my combo boxes.

The function works fine but occasionally I get an

Operator/Operand Type Mismatch

I am using the following in the refresh event of my combo box


this.displayvalue=LOOKUP(V_SPENDOFFS.SPENDOFF,V_ticket.divsubarea,V_SPENDOFFS.DIVSUBAREA)


If I tell the program to resume the line of code from where it crashed, the line excutes just fine, which indicates to me that some timing factor is involved.

I do have a timer running on the form (for fancy tooltips)

I have checked the data types for the underlying tables involved and they seem to be fine.

Has anyone else come across this problem???