Me!VatRate002 = Dlookup("VatRate","q04VatRate","VatCode03=" & Me!VatCodeSales002)
I am missing something. VatCode03 is a field in foreign query q04VatRate, it is always a string value i.e. SS.
VatCodeSales002 is a field in local query, also always a string.
I assume because of strings, there must be a colon or two??