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.
|
Similar Threads
