Error message from Combo box

[jlg5454]

I have a record input form that includes a combox box that filters for a record for editing. If I select a record from the combo box make my changes and click the save button everythings fine. The problem is when I go to select that same record from the combo find box, I receive an error message: "The Data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit your record." This database is only available to me for now. How can I correct this?

Thanks,

Joe

 

[djayam]

Hi Joe,

I just had this problem and it took me ages to fix it!! For me it was on clicking a button which added a record.

I added Form.Requery to the OnClick property. I guess you would put it in the AfterUpdate property.

Hope it works for you,

Jason

 

[jlg5454]

Thanks! worked great! I was putting the combo box as requery.