Like the title says, when I try to add a new record to my subform via a button, it doesn't work UNLESS I manually enter some information in the first field then save it.
My button has the following code:
My button has the following code:
Code:
Private Sub btnSave_Click()
With CurrentDb.OpenRecordset("tblObservation")
If Not .BOF And Not .EOF Then
.MoveLast
.MoveFirst
.AddNew
!IQAID = fldIQAID
![fldCategory] = fldCategory.Value
![fldFinding] = fldFinding.Value
![fldAuditorNote] = fldAuditorNote.Value
![fldLAnote] = fldLAnote.Value
![fldAuditorID] = fldAuditorID
.Update
End If
End With
DoCmd.RunCommand acCmdSaveRecord
subFrmObservation.Requery
End Sub