Dependent combo boxes & result shown in text box

[viperor]

I'm new in MS Access & VB programming. I was trying to make dependent combo box for a while and it worked after 3-4 days research. However, the next step got me stuck to retrieving data from a certain cell in a single table (no relationship tables done) as shown in the sample table below:

Sr..........Area.....Type.....Number.....Information
1...........ABU..... RES..........1..........Information A1
2...........ABU..... RES..........2..........Information A2
. . . . .
5...........ABU..... IND..........1..........Information A5
6...........ABU..... IND..........2..........Information A6
. . . . .
10..........DXB..... RES.........1..........Information D1
. . . . .
13..........DXB..... IND.........1..........Information D4
. . . . .
. . . . .
28..........SHJ..... IND..........3..........Information S9

I have attached an image of my GUI done in MS Access to simplify my explanation.

I have managed to create dependency combo lists and display unique names of three fields (Area,Type & Number) from the table. However, I couldn't get hold on the required command to display the the "Information" column corresponding to the three choices into a text box " txtInfo" as shown in the GUI Image. I want it to display whenever the user makes all combo selections & pressing the Accept button.

A sample of the command used for combo list dependancy was:
cboType.RowSource = "Select Distinct tblInfo.Area From tblInfo where tblInfo.Area = '" & cboArea & "' Order by tblInfo.Type;"

I'm avoiding using relationship tables therefore please if there is any possible way to display information in the text box after selecting the choices & accepting it, please write the whole command (if possible)

cboArea => Area Combo box
cboType => Type Combo box
cboNumber => Number Combo box
txtInfo => text box
tblInfo => table

Thank you