Is DLookUp What I should be using?

[cameronaziz]

Hi

Im pretty new to access. I have a form (called TestAdd) where you fill in information that populates a table called "Tests"

I also have a table called CPTCodes with 3 columns: CPT_Code, Test, Prices.

One of the fields is called "CPTCode." That field has a row source of

SELECT CPTCodes.[CPT_Code], [CPTCodes].[Test Name] FROM CPTCodes ORDER BY [CPT_Code];

Lower down on the form I want to display the price of the test. The prices of the tests are in that table called "CPTCodes"

I want the price of the test, according to the CPTCode in the form, to be displayed on the form.

[cameronaziz]

The row source for my box now is

=DLookUp("[Price]","CPTCodes","[CPTCode] = " & [Forms]![TestAdd]![CPTCode])

but it just displays the Record's "Price" no matter what the CPTCode is on the form.

[cameronaziz]

FIGURED IT OUT!

=DLookUp("[Price]","CPTCodes","[CPT_Code] = " & [Forms]![TestAdd]![CPTCode])