Trouble with autofill of form

[Garn77]

I have a main form with two combo boxes, and a subform with two text boxes. All the information for all four boxes is included in a query, with the etered and generated information to be recorded in a seperate table (the reason for this being that want to record other data with the mentioned four text boxes in the table). What I want to occur is as follows.

I select from the Reference combo box on the main form a number which prompts the other combo box (Habitat) and the two text boxes in the subform (Name and Description) to be autofilled with information that is related to the selected Reference number. The information is stored in the Index Query, with each reference number having related name, description and habitat column information.

So once the reference number is selected these boxes will be autofilled and the information then stored in a table along with other data that I enter in.

I have tried:
Me.text0=Me.Reference.Column(0)

statement but to no success. Thus is based on the click() statement.

I have also included:

Me.subformcontrol.FORM.control and,
Me.subformname!textboxname=Me.Reference

to link the subform and main form.

Can anyone help with this, I think I'm close but not there yet.

Cheers