Using multiple Combo boxes with text boxes

[djsmiler]

Hi All

I have got a combo box on my form which is pulling data from a table.
The filed it stores the data to is fine.
But i am trying to get all the fileds from my table to display in text boxes when the main combo box is used to select the record.
The fields I want to dislay is Branch code branch name telephone number home feeder.

The branch codeis the field where i am selecting from the combo box and the rest of the fields I would like displayed when the record is selected.

Please help.

As I am stuck.

Thanks

Steve

 

[djsmiler]

I have tried the following mate

Total time= [Time Resolved] - [Time Started]
= [Time Resolved] - [Time Started]

Both of these expressions were put into the control source of the text box.
Seperately.

I will also need the text box to display the results in the total time field of the query table that i am using to store my data.

Cheers

Steve