Unbound Text Box to Subform

[blocksey]

Hi I have an unbound text box, that is determined from a users Environ details, and i would like to link this to a subform



the subform is made from a cross tab query and basically i only want the subform to show the users details which is in the text box



Any assistance would be greatly apprecaited

Thanks

[ItsMe]

My approach would be to use the Main Form's On Current event to update the subform's recordsource. A popular approach is to add criteria to the subform's filter criteria. Both techniques require VBA.