I've gotten my query to work, but not in the way I wanted to. I want to use a combo box to pass the value to be queried: You select a value from the combo box, and click on a submit button. That runs the query with the selected value. Would that have to be done in the VB Code or in the submit buttons properties box?
The information I want passed to the query is AECClass (ranging from 001-005)
I don't think this is right, but here's the code I'm using on the submit button
stQuery = "SELECT tbl2004- AIA Attendance Log.* FROM tbl2004- AIA Attendance Log"
stQuery = stQuery & " WHERE " & cboAECSearch.Value & " = 'AECProgram'"
stDocName = stQuery
stDocName = "qryAECClass"
DoCmd.OpenQuery stDocName, acNormal, acEdit