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.
i have created this code within one of my forms as a command button. i aleady created a word document with bookmarks called FACULTY.doc and when the button is pressed the data which is in the active form are exported to the word document but the data from the field Housename doesn't get exported...