Lookup from level 3 cascading combo boxes?

[A|ex]

Is it possible to do a lookup on the last level of a combo box? at the moment i have 3 levels, the last level displays a range of dates (terms) and i want it to look up all the values for that one term (in other words all the data from that one row).

Is it possible? the term used in the combo box isnt a primary key, but i know its possible to do this in excel, can you do the same in access? if so how?

Cheers

 

[Mile-O]

Research the DLookup() function.

 

[A|ex]

my code i think is wrong

=DLookUp([PPP],[tblTerm],[tboPPP]=[cboTerm])

so it looks up PPP from table Term and makes the text box PPP = PPP in table Term based on the combo box Term. ?

 

[A|ex]

=DLookUp("[PPP]","[tblTerm]","tblTerm!Term=[cboTerm]")

All i want is the PPP of the term selected in the box above, only problem is there are many levels of combo boxes :/

 

[A|ex]

Hmm another problem is how do i store the values in the drop down box?

 

[A|ex]

Where does access store the values and please can u look at my Dlookup?