dlookup from another form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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])
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to use DLOOKUP in a query to bring in a value directlyfrom a control box in a form? 3
dlookup with if 1
DLookUp behavior 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Dlookup error 13 7
Get a number from a table to a form. 0
dlookup 2
DLookup in Text box to show Currency (number field) 9

Back
Top