List controls in Microsoft Access, such as the combo box and list box, offer choices to the user.
From their point of view, they don't have to enter anything — they simply select an item.
' avar Exception List = list of control names NOT to copy values over to.
When the Choose Builder window appears, highlight Code Builder. To do this, we need to add a procedure to the Before Update event of the Microsoft Access form.The Before Update event occurs before changed data in a control or record is updated.Similarly, if the form is a subform, any fields named in Link Child Fields will be the same as the record we are copying from, so you do not need to explicitly exclude those either.
If you do not wish to see any error messages, you could just set the Before Insert property of the form to: 'Purpose: Carry over the same fields to a new record, based on the last record in the form. ' str Err Msg = string to append error messages to.Handing over a bit of control, in the right circumstances, can be helpful for everyone, including you.