J
|
Jane 2/13/2007 |
Greg, Function BeforeAdd(dict) strUpdate = "update Logons set GroupID='new value' where OrgID=" & dict("FieldName") dbConnection.Execute strUpdate BeforeAdd = True End Function
|
G
|
Greg Cantwell author 2/13/2007 |
I couldn't seem to get that to work..it didn't change the field Greg, you can do it using events. Proceed to the Events tab, select Before record updated event and add your code in it. Here is a sample code: where FieldName is your actual table name in the main table. |
J
|
Jane 2/15/2007 |
Greg, Function BeforeEdit(dict, where) strUpdate = "update Logons set GroupID='new value' where OrgID=" & dict("FieldName") dbConnection.Execute strUpdate BeforeEdit = True End Function |