I am trying to get my front-end DB to compare a value in a linked table from the back-end to a value in a local table from the front-end. Below is a truncated snippet of my code:
===========================================================
Dim intLocal As Integer
Dim intLatest As Integer
intLocal = "Tables!tblLocalVersionNumber!intVersonNumber"
intLatest = "Tables!tblVersionNumber!intVersonNumber"
If intLocal = intLatest Then ...
I get "Error 13 - Type Mismatch"
=======================================================
I originally wrote the code with the variables "as string" and I didn't get the error, but it handled the variable as not being equal, even though the values in both tables ARE equal.
Thanks in advance for your help...
Clint Galliano
Halliburton Energy Services
BAROID PSL
"Done ONCE, Done RIGHT!"
===========================================================
Dim intLocal As Integer
Dim intLatest As Integer
intLocal = "Tables!tblLocalVersionNumber!intVersonNumber"
intLatest = "Tables!tblVersionNumber!intVersonNumber"
If intLocal = intLatest Then ...
I get "Error 13 - Type Mismatch"
=======================================================
I originally wrote the code with the variables "as string" and I didn't get the error, but it handled the variable as not being equal, even though the values in both tables ARE equal.
Thanks in advance for your help...
Clint Galliano
Halliburton Energy Services
BAROID PSL
"Done ONCE, Done RIGHT!"