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). The table in the other table can have multiple values. 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

 

[RuralGuy]

It looks like you are using the Evil Lookup Fields.

 

[Kryst51]

Also this is a duplicate of a thread from this morning.

http://www.access-programmers.co.uk/forums/showthread.php?t=176856

 

[pop]

Yes, but I had no answer in the other section for 2 days, but had one in 30 min in this, sorry for the double post but I need an answer fast.

 

[RuralGuy]

Yes, but I had no answer in the other section for 2 days, but had one in 30 min in this, sorry for the double post but I need an answer fast.

I would have to ask why you first put your issue in the Report forum? It does not seem to be related to Reports in any way.

 

[pop]

Well, it was for a report haha, shouldn't post it there.