I need to add a Yes/No field to a table. I know I can do this in design view. Next I want to loop through the table and set it to Yes if certain fields are null. What I need help with is the VBA looping part and setting the boolean field to Yes if the fields being checked are null.

I need to add a Yes/No field to a table. I know I can do this in design view. Next I want to loop through the table and set it to Yes if certain fields are null. What I need help with is the VBA looping part and setting the boolean field to Yes if the fields being checked are null.

What is the table name and structure?
Go ahead and add the field to the table in design view.
We can help with the looping.

Why not just use an update query? It is faster and more efficient.

Why bother storing a value that can be retrieved at any time anyway?