Access 2003 SetValue on Subform

H

hspgapsemc

The macro below works on a database developed in an earlier version of
Access. I have copied this macro into another database developed in Access
2003 using the same fields and tables, but now it does not work.

2 Form Fields: College Code and College

Form Property: After Update

Action: SetValue

Item: [Forms]![Inquiry: Express]![COLLEGE HISTORY - Inquiry:
Express]!
Code: 
Expression:  DLookUp("[COLLEGE CODE]","COLLEGE DATABASE CODE COMBO BOX
QUERY","[COLLEGE NAME] = Forms![Inquiry:  Express]![COLLEGE HISTORY -
Inquiry:  Express]![COLLEGES ATTENDED]")

Are there changes in Access 2003 that cause this macro to error?

My objective is to type the name of a college in the college field.  There
is a combo box based on the query named in the macro.  Once you tab out of
the college field the code number should automatically fill.  The form is set
up that the college code field appears and is tabbed before the college field.
 
Top