Automating Updating on a Subform

[Dorv]

All,

I'm creating a Performance Tracking database at work, for disiplanary actions...

When on the subform, you update the field VioCode I want it to check that value against a table called PtsSource, and find the value of SourcePoints where VioCode (from the form) is equal to SourceCode (from the table).

(VioTableForm) is the subform

I had a macro created that had
SetValue
Item - [Forms]![VioTableForm]![Points]
Expression - DLookUp("[SourcePoints]","PtsSource",[PointsSource]![SourceCode]=[Forms]![VioTableForm]![VioCode])

HELP!!!

 

[PHV]

DLookUp("SourcePoints","PtsSource","SourceCode=[Forms]![name of main form]![VioTableForm].Form![VioCode]")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886