I have a table "School" with Schl_no and Schl_name.
I have a table "Exam" with School which joins on Schl_no
On Form "SearchQuery" I have a command button that looks up School, Student_name and Course, which returns the correct answers.
My client says her staff doesn't really know the school numbers, but the names (some of which are quite long).
Is there a way to do a DLookup (or other lookup) with the given school name (or abbrevaitoin) and return all possible records for school and then cull based on the other criteria?
I have been unsccessful with DLookup:
S1 returns the proper value from the dialogue boxDim S As String
Dim S1 As String
S1 = InputBox("Enter School Number", "School", "*")
S = DLookup("[Schl_no]", "School", "[Schl_name] ='" & "*" & S1 & "*" & "'")
S returns null
Thanks