dlookup from another form

C

CO

I am trying to dlookup the 20yrrt column in the form 20yrfed based on the
date in the current form (15thprior) and the date in the 20yrfed form (15th
prior) as well. What is wrong with my statement?

=DLookUp("[20yrrt]"," Forms![20yrFed] ","[15thPrior] = " &
Forms![20yrFed]![15thPrior])
 
R

Rick Brandt

CO said:
I am trying to dlookup the 20yrrt column in the form 20yrfed based on the
date in the current form (15thprior) and the date in the 20yrfed form (15th
prior) as well. What is wrong with my statement?

=DLookUp("[20yrrt]"," Forms![20yrFed] ","[15thPrior] = " &
Forms![20yrFed]![15thPrior])
Click to expand...

You can't use Dlookup() against a form. The second argument needs to be a table
or query.
 
Top