You may use an Access form bound to a specific table as a way to update that table's records. But you may want to use the same form as a data entry-only form, using VBA to validate fields before writing data to a record on a table. Here's a procedure that unbinds most of the controls that may be found on a form, and optionally remove the form's record source.

Continue Reading: Unbind an Access Form »