Get data from a table in a table

[pop]

I have a text box which get value in a form which takes its value from a table, which looks like this :

=[Forms]![frmRequest]![cboAsk].[Column](1)

from there its ok, but my problem is that I have a Data type that takes it data from a table (table in a table). So how can I take that value, I tried this but it didn't worked:

=[Forms]![frmRequest]![cboFrom].[Column](5).[Column](1)

What should I use as formula?

Thanks,

Cope

 

[pop]

I forgot an important detail, my table which is in the other table can have multiple values.

Thanks,

Pop

 

[HAMMAMABUARQOUB]

did you try Dlookup!
xample:
if you have a field names id ID from Table 1, you wan to get the Ename of this Id from table 2 "must not contain dublicate IDs) type:

Me.Ename = Dlookup("[Ename]","[Table2]","[ID]=Forms![Form1]![ID]")

that's what i understood!