Access 2007 Dlookup function

  • Thread starter Thread starter nybaseball22
  • Start date Start date
N

nybaseball22

Hello,

I recently upgraded to Access 2007 from 2003. I have found that most
of my DLookup funtions are not working. I had one that looked up
based on info from a subform. An example of the coding is below.
Does anyone know if I need to change this code to work in 2007?

=DLookUp("[Station]","[AutosGasStats1Station]","[CountOfStation] = " &
DMax("[CountOfStation]","AutosGasStats1Station"))

Thank you.
 
Back
Top