Additionally, ff the student name the Bound Field of the combo0 Combobox? If not, which column does it appear in, keeping in mind that going from left to right, the 1st column is Column(0), the 2nd column is Column(1), etc.
selText is the wrong property to be using here. If the student name is the Bound Field, you'd simply use
Me.combo0.Value
or, even simpler
Me.combo0
From the name, I assume that stdName is just that, a name, i.e. Text. If that is correct, the Where part of the command would be
"stdName = '" & Me.combo0 & "'"
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007