create a query to update the records.
First create a select query that will return all records you with to update. Criteria in the entity field would be "is null".
Once you are happy the query is returning the results you want to update, click update on the design tab and add what you want to update it too.
Any problems let us know.
Andy
thanks Andy, that did the trick!
A bit more info......
You can only "Execute" action queries. Action queries are Insert, Update and Delete queries. SELECT is NOT an action query.
Also, you used "SQL" as a variable name in your code. Note that "SQL" is a reserved word in Access and shouldn't be used as object/variable names.