Detect Access Table Cahnges
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 DoneMe.OwnerBindingSource.EndEdit()IfMe.ALS_Data_ExplorerDataSet.Owner.GetChanges()IsNotNothingThen MsgBox( "Owner Changes")TryMe.OwnerBindingSource.EndEdit()Me.OwnerTableAdapter.Update(Me.ALS_Data_ExplorerDataSet.Owner)Catch exAs ExceptionMsgBox( "Owner update failed for unknown Reason - contact Kumar")EndTryEndIf |

