Thanks Jon K for the sample DLookup file. It works fine, but when I the code below in my own database query I get asked for a parameter value for site_ref when I hoped that it would automatically return all the values into field Area2:
Area2: DLookUp("[ContigBL]","Woodareas","[Woodcode]='" &...