run update query from form

[Dawnit]

Hi! anyone know how I might be able to run my update query when I'm using my form and a particular field loses focus, or something similar, OTHER THAN a command box?

 

[LonnieJohnson]

In the field's After Update or On Lost Focus event properties, you can use either of the Docmd methods for queries:

1. Docmd.OpenQuery "YourUpdateQueryName"

2. Docmd.RunSQL "UPDATE CustTable SET CustTable.Name = 'Dawn' Where CustTable.Id = 1"

The second example is the actual SQL for your update query. ljprodev@yahoo.com
Professional Development
MS Access Applications