I have a form, named “frmDEDB_main_Form”. This form lists different people going to different schools. I want to place a Combo box named “School” to select a school that will show anybody that wanted to go to that school. This information comes from my table, named “Nominees” in Columns DEVector1, DEVector2, DEVector3.
So I put in my combo box and in the Row Source, I put the language, "SELECT Nominees.DeVector1, Nominees.DeVector2, Nominees.DeVector3, Nominees.NameField FROM Nominees ORDER BY Nominees.Percentile; "
Then, in SQL, I put "Private Sub Combo67_AfterUpdate()
’ Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.Find “([Devector1][DeVector2][DeVector3]) = '” & Me![Combo67] & “'”
If Not rs.EOF Then Me.Bookmark = rs.Bookmark"
When I go back to my combo box, it will not show any schools for me. What am I doing wrong?
Table: Nominees
Columns: Need Info from “DEVector1, DEVector2, DEVector3”, and want it sorted by the Column “Percentile”
Form: frmDEDB_main_Form
Combo Box: School
Needs to show every school I have in the Table School List DPAFE" specifically Column “School”
When I click the school, I want it to show only the records of those individuals that have that school in DEVEctor1, DEVector2, DEVector3.
Help!?!?!?