Comments by Tony Palumbo (Top 1 by date)

Hi David,

Here is code:

'try
If tempDate = Today And bsRunInformation.Current("UniqueNumber") = Fields(1) Then
frmMain.bsRunInformation.Current("Description") = StripString(Fields(2))
frmMain.Validate()
frmMain.bsRunInformation.EndEdit()
frmMain.TblRunInformationTableAdapter.Update(frmMain.DsSkySkor1.tblRunInformation) 'Soon as I call this I get DBConcurrencyException not handled

'Catch ex As DBConcurrencyException

'End Try
MsgBox("Update current record " & Fields(2))
Else

frmMain.TblRunInformationTableAdapter.FillSingleRow(frmMain.DsSkySkor1.tblRunInformation, Today, Fields(1))
frmMain.bsRunInformation.Current("Description") = StripString(Fields(2))
frmMain.Validate()
frmMain.bsRunInformation.EndEdit()
frmMain.TblRunInformationTableAdapter.Update(frmMain.DsSkySkor1.tblRunInformation)'Soon as I call this I get DBConcurrencyException not handled
'Catch ex As DBConcurrencyException

'End Try
End If