A
A.C
Help with SetValue Action
I have a relational database in access 2003 with 2 tables Customers and
Lawn Treatment Service Dates. In the customer table I have a text field
named “1 completed” that I want to populate with the word “Complete”
when I enter the number 104 in a data entry form for the field named
app# also text field from Lawn Treatment Service Dates Table.
I have created a macro and attached it to the after update property of
the app# field,with the Condition- [app#]=104, Action -SetValue ,
Item-[customer]![1 complete] and Expression- “complete”. This give me a
error message that the object doesn’t contain the automation object
‘customers’
Thanks A.C.
I have a relational database in access 2003 with 2 tables Customers and
Lawn Treatment Service Dates. In the customer table I have a text field
named “1 completed” that I want to populate with the word “Complete”
when I enter the number 104 in a data entry form for the field named
app# also text field from Lawn Treatment Service Dates Table.
I have created a macro and attached it to the after update property of
the app# field,with the Condition- [app#]=104, Action -SetValue ,
Item-[customer]![1 complete] and Expression- “complete”. This give me a
error message that the object doesn’t contain the automation object
‘customers’
Thanks A.C.