Macros

[eramirez]

Hi.

I am trying to add a Macro that sets the value of one field based on the value of another field. The field with the value already exists in the database. I added the new field that I want populated. For example.

CONDITION ACTION
[TYPE] IN ("ALDERMAN","CHA",VFC") SETVALUE

ITEM: [CATEGORY]
EXPRESSION: "COMMUNITY"

when I attach this macro to the TYPE field (in the event tab,"On Exit") and attempt to run, I get an error message saying that Access can't find the field "TYPE". I don't understand this since TYPE was already in the database (in the table and form). Does anyone know what I am missing or doing wrong?

Thanks
Enrique Ramirez[/code]

 

[Norie]

Enrique

Are you sure the name of the control on the form is TYPE?

 

[eramirez]

pretty sure it is. The TYPE field I created in the table, then added it to the Form, the Name: TYPE and Control Source: TYPE. This is the message I get:

"Microsoft Access can't find the name 'TYPE' you entered in the expression.
You may have specified a control that wasn't on the current object without specifying the correct form or report context. To refer to a control on another form or report, preceded the control name with the name of a collection, usually either Forms or Reports, and the name of the form or report to which the control belongs.
For example, Forms![Products]![Units in Stock]"

I am not even sure what this means.