I figured it out but is there a better way?
Private Sub cmdSaveVersion_Click()
'Required Reference: Microsoft DAO 3.6 Object Library
Dim db As DAO.Database
Dim rs As DAO.Recordset
'Check if there is a version number
If IsNull(Me.txtChangeVersionNumber) Then
MsgBox "A version number must be provided! ", vbCritical, "Entry Error"
Exit Sub
Else
'Update table master version
Set db = CurrentDb
Set rs = db.OpenRecordset("tbl-version_fe_master", dbOpenDynaset)
rs.Edit
rs!fe_version_number = Me.txtChangeVersionNumber
rs.Update
rs.Close
Set rs = Nothing
'Update table version
Set db = CurrentDb
Set rs = db.OpenRecordset("tbl-fe_version", dbOpenDynaset)
rs.Edit
rs!fe_version_number = Me.txtChangeVersionNumber
rs.Update
rs.Close
Set rs = Nothing
Me.txtVersion_fe_master.Requery
Me.txtFe_version.Requery
End If
End Sub