Results 1 to 1 of 1
Thread: Database/Form/SQL Help
Oct 6, 2010, 10:01 #1
- Join Date
- Oct 2010
- 0 Post(s)
- 0 Thread(s)
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?
Columns: Need Info from "DEVector1, DEVector2, DEVector3", and want it sorted by the Column "Percentile"
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.