I want to check the ID of an autonumber assigned by MS Access. The following is my current vb code:
!CustomerID = frmCustomer.List1.Text
!LastName = frmCustomer.txtCustInfoLast.Text
!FirstName = frmCustomer.txtCustInfoFirst.Text
!employeeID = employeeID
!Date = Date
!Note = frmCustomer.txtCustInfoNote.Text
The only field no included in this update is the NoteID, which distinguishes the different notes available. If 2 notes are exactly identical except for the NoteID, how do I determine what NoteID the note that was added here has?