I have used the DLookup function many times in VBA, but I am trying to use it in a slightly different manner this time and I can't figure out wheat I am missing.
I have a table called MarketRates, it has 2 fields; CCode and Rates
I have a form that I want to look up the rate based on the code...