General information
Category:
Coding, syntax & commands
Title:
Bug in LOOKUP() function - Anybody else come across it
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???
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only