Command Button, Variable, Dlookup is it possible?

[WSpivak]

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:

Dim S As String
Dim S1 As String
S1 = InputBox("Enter School Number", "School", "*")


S = DLookup("[Schl_no]", "School", "[Schl_name] ='" & "*" & S1 & "*" & "'")

S1 returns the proper value from the dialogue box
S returns null

Thanks

[Welshgasman]

Use a combo to select the school name (no typos invoved then) and get the school number from an additional column.
You are asking for school number yet are using it as school name?

[moke123]

Google "Cascading combo boxes"

[WSpivak]

Thanks for you help... didn't do what I wanted, but found a simple workaround that suffices until I have more time to devote to solving the issue.

[Welshgasman]

Thanks for you help... didn't do what I wanted, but found a simple workaround that suffices until I have more time to devote to solving the issue.

Care to share?
These forums are here to help other people after all?

[WSpivak]

I just put a standalone combo box, so they can just find the datapoint. Nothing brilliant, but it lets them move forward...