After Update (Set Field to Query Field)

[thabounceisback]

I have an after update event that sets a field to value [Query]![Field]

Access is giving me the error that the "Identifier [Query]![Field] could not be found". Any ideas on what is going on or how I should proceed?

 

[pbaldy]

It would help to see the code, but you can't refer to a query field like that in a macro or VBA. You can use DLookup() in either or a recordset in VBA.