I would like to fetch a record from a drop down field in the main form to a text field in the sub form. can you tell me how to do it?

thank you,

michael