...but i'm giving it a shot!

I'm working on a form for a personel database for a theatre company. I want to have my new magical form be able to sort by position and then the subform be continuous with information of what person, their tax information and contact information. However the money stuff and phone number and address are all in seperate tables.

Is it possible??

the simplest solution, i can think of at the moment, would be to have the record source of the subform being a query with the criteria equal to the combobox or list box that you are using for the search and in the afterupdate event of that combo box have the subform's recordsource requeried.

e.g.
SELECT tblsuberrors.suberrorid, tblsuberrors.errorgroup, tblsuberrors.suberrortype FROM tblsuberrors WHERE (((tblsuberrors.errorgroup)=Forms!fsubartrainentry !cboerror));

in the above i'm picking select all the suberrors where the errorgroup is in the combobox i just changed.