Detect Access Table Cahnges

Hi all,
I am trying create form which displays the data using combo selection("PIN" Unique field). I am trying to make it check if the data has changed and store it if it has. I and using databound for the combo box. The problem is that when I change PIN in combo box(Which is for naviagation). The Getchanges() function assumes that it has data changes. How can I get rid of this problem? Any input would be appreciated. Thanks
- kumar


Me.Validate()

'Check if the "Owner" record source has been changed, If Yes Record the Change Done

Me.OwnerBindingSource.EndEdit()

IfMe.ALS_Data_ExplorerDataSet.Owner.GetChanges()IsNotNothingThen

MsgBox("Owner Changes")

Try

Me.OwnerBindingSource.EndEdit()

Me.OwnerTableAdapter.Update(Me.ALS_Data_ExplorerDataSet.Owner)

Catch exAs Exception

MsgBox("Owner update failed for unknown Reason - contact Kumar")

EndTry

EndIf



[2462 byte] By [skumar] at [2007-12-17]