from the sound of it, you need to split your table
- suggest you post your table design plus some sample data
I'm a bit confused - you have accountno in the table - are you saying it should be one account per studentID and you need to correct the data?
Or are you saying you want to filter the subform on studentID and accountno?
No, many students, many acount no and all that in same table "account".
is this posible?
so you want the subform to show only records related to studentid and accountno?
If so then for your subform set the linkchild and linkmaster properties to
studentid; accountno
use square brackets if you have spaces