When a user makes a change to the first field in a form, that change is not saved until the user has moved on to the next record. Rather than having the user tab through all the controls on the form to move to the end of the record, you can add a Save Record button that the user can click to save the record immediately after the change. Follow these steps:

  1. Open the form in Design view.
  2. Right-click any toolbar and click Toolbox. Click to activate the Control Wizards button, if necessary, and then click the Command button tool. (In Word 2007, on the Form Design Tools tab, click to activate the Use Control Wizards button in the Controls group, if necessary, then click the Command button.
  3. Click and drag in the form where you want to locate the command button.
  4. Under Categories, click Record Operations.
  5. Under Actions, click Save Record.
  1. Click Next.
  2. Click Next.
  3. Enter cmdSaveRecord.
  4. Click Finish.

Miss an Access tip?

Check out the Microsoft Access archive and catch up on other Access tips.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.