1. Create 2 text boxes. Name them: txtEmployeeFirstName and txtEmployeeLastName
2. Create 2 Buttons. Name them: employee_add and employee_save
3. Use the code below:
Private Sub employee_add_Click()
txtEmployeeFirstName.Enabled = True
txtEmployeeLastName.Enabled = True
Private Sub employee_save_Click()
If IsNull(txtEmployeeFirstName) Then
MsgBox "please enter a first name"
If IsNull(txtEmployeeLastName) Then
MsgBox "please enter a last name"
!EMPFirstName = txtEmployeeFirstName
!EMPLastName = txtEmployeeLastName
txtEmployeeFirstName = ""
txtEmployeeLastName = ""
txtEmployeeFirstName.Enabled = False
txtEmployeeLastName.Enabled = False
You will need to create an unbound text box for every field for the table, in this example the fields are first name and last name, if you had more fields, then obviously you would create more text boxes and in the:
![FieldNameOfTable] = [TextBoxOnForm]