where *** is the name of what ever field is next. I've got error messages for required fields left empty, and no other fields are 'required' in either my form or table.
below is ALL the code for the form, in bold is the line which is highlighted when debug is selected.
' into a string variable.
MsgBox "Please enter a First Name"
MsgBox "Please enter a Last Name"
MsgBox "" & firstname & " " & surname & " was successfully added."
if all the fields are filled in then the form submits.