Are you asking how to change value of a field for all records? You can execute an UPDATE action SQL. What exactly do you not understand about UPDATE action? Use Access query designer or wizard. If you want to automate in VBA, use DoCmd.RunSQL or CurrentDb.Execute methods.