Have an access 2003 db of student training. In this db there is a Trainingmain table which holds all of the training records consisting of StudentFirst , StudentLast, TrainingTitle, TrainingDate.
I have a form that I would like to use to search by. SearchFrm contains a combobox. Problem is, the combobox is populated by a combination of the studentfirst and studentlast :
SELECT [Studentfirst] & " " & [Studentlast] AS Expr1
GROUP BY [Studentfirst] & " " & [Studentlast];
Now with this as the criteria, how do i then populate the query (based on the Trainingmain table if the combo box is actually two fields in one.