[Access 2003] How do I populate a textbox on a subform in a module

I have this subform "subfrmResults" with text boxes named

Open
Insured
Insurer
Policy_Number
Start_Date
End_Date

I have a linked table named "Database" memInsured, memInsurer, txtPolicy_Number, txtStart_Date and txtEnd_Date

A main form "frmMain" with commandbuttons named the same as above without the naming conventions and a close button

The database information doesn't change. But I want to display it in the unbound subforms' (Datasheet view) text boxes depending on how the user wants to sort it(by insured or insurer, etc)

What I've been trying to do is when a user clicks on say "Insured" to call codes in a module to populate the subform in the sorted order and then open the form "frmResults" which has the subform attached.

Many Many thanks for your help, I have a short about of time to get this done so I'm hoping for quick responses to this.

Believe me I know this is easy to do, but my brain is not functioning.

Again Thanks for you help that so desperately needed.