I have one Combo Field and one Text Box Field in my Access DB's Form.
I would like to have my 2nd Text Box Field to get the data from a Table based on the Combo and Text Box Field Data.

Is it possible? or auto-fill in the Access text box only can base on a combo box?

Example:-
The combo field was selected from table-1 consists of the equipID\_PK and equipDesc.

The 1st Text box contains the data obtained from the table-2 Block, Floor, and Room. When Block was selected, the floor and room (1st Text Box) will auto-filled.

Based on the combo field (equipDesc) and 1st Text Box data (Room Field), I want the 2nd Text Box to fillup a subEquipDesc which is from Table-3.

I need help on how to set up this Table-3. Some of the Equipment (EquipDesc-in Table-1), when placed in a different room, will have a different description (different software loaded), I called it SubEquipDesc.

Hope is clear and let me know if more explanation is needed. Thanks.