Compare value in FE table with value in BE table via code

[Tarnish]

Hi all,

I need to compare a value in a table on the front end of a db with a value in a copy of the same table (but with a different name) on the back end. I have the back end table linked in the front end file.

I could easily do it using a form based on a query, but I want this code to run via the load event of a form that's already developed and I'm drawing a blank.

All I'm going to do is run an If/Then statement based on the value of the front end table field compared to the value of the backend table field. Both tables have just one record and one field.

Please "fill in the blank"!

Thanks,
T

 

[PWise]

if dlookup("fieldname","tablename")=dlookup("fieldname","BEtablename") then

     .....
Else
     ..........
End if

 

[Tarnish]

pwise,

Thanks...sometimes the ole' memory ain't what it use to be!

T