Delete Information In Column with Code

[mrssevans]

I am needing to use code to go through a table on the exit of a form and change all the checkboxes that = -1 to 0. Is there some code I can use for this or is this even the best way to change it?

It thought maybe something like

i=1
For i = 1 to EOF
(I need to reference the column here).value=0
i=i+1
Next i

 

[Mile-O]

Don't have time to go into it in detail but if you are just going through a table and changing a yes/no field's state then just run an UPDATE query to do it for you.

 

[mrssevans]

Will give that a try...thanks

 

[pdx_man]

Create an Update query that runs on exit.

UPDATE Table5 SET Table5.MyVal = 0

** Edit **

Got distracted and forgot to hit Submit and you guys are Johnny on the spot!!