On my form, I have a UserName combo box that is the first field to receive the focus when the form opens. The default value is set to "=UsersFormalName()" from the function below.
The problem is that the record goes right into Edit mode (the little pencil in the upper left corner) as soon as the form is opened or a "new" record is added. Normally the mode would remain in "view" until user starts typing in a field (the little triangle in the upper left corner).
How can I stop the New record from going right into Edit mode but still have the UserName combo be the first field selected when the form is opened? Ideally I would like the Edit to start when the user tabs away from the field or selects another name from the combo.
Public Function UsersFormalName()
'DATABASE CONTAINS TABLE T_PEOPLE
On Error GoTo ErrorHandler_Err
Dim db As Database
Dim rst As DAO.Recordset
Dim strSQL As String
Set db = CurrentDb
strSQL = "SELECT tbl_People.PeopleName " & _
"FROM tbl_People " & _
Set rst = db.OpenRecordset(strSQL)
UsersFormalName = rst.Fields("PeopleName").Value
Set rst = Nothing
530 Exit Function
Select Case Err
'ErrorDetails = ErrorHandler(FormName:=FormNameConstant, ProcedureName:=ProcedureName, _
ErrNumber:=Err.Number, ErrDescription:=Err.Description, ErrLine:=Erl)