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.
 

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

Dynamic Naming of Form Button 3
linking fields from different tables in same database 4
Linking fields in different table in same database 1
update a field by inputting data in a different table 1
Please Help - Pivot Table Trouble 0
Pivot Table Averages 0
Access 2003 View Results From Bound Column 1
Parameter Query Problem 7

Top