Search results

of course I mean #name?

ah I get it needs to go in the VB editor. Still does not work though I am using Forms!Overall!frm_student.Form.RecordSource = qry_student Me.Form.Recalc Does do something though as when I select group from list box then Name# gets fired back in every box on the subform. SO I see this as...

Thanks for getting back to me and I can see what your code is trying to do but I can't get it to work. The form is called "overall" and the sub form "frm_student" with a query named "qry_student" I know I am being ignorant in this forum but this is all brand spanking new to me, so please be...

BTW if this does not make sense then let me know and will reword it. Happy to email someone with mdb file if they think they can help too. David

OK first go here and access newbie so excuse my ignorance in advance :) I have a form which has list box of student groups, the subform on the page then should list the students depending on the group clicked on the list box. So if you select group 1 from list box then students appears in the...