i tried the dlookup but for some reason i get the error '2001 you canceled the previous operation'
this is what it looks like:
Dim bri As String
bri = DLookup("[Housename]", "Application", "[Surname] = " & Forms![License]![Surname])
Housename, surname are text fields.