Moving from Subform Problem (1 Viewer)

[Keith]

I have a form with an option group to select subforms to be displayed.To save space on the main form I have added a subform (frmSubService) to the option group to display some of the data that was originally on the main form. The subforms data source is the same as that of the main form but only displays five fields.

After editing data in the subform frmSubService, if I then click on a field on the main form no problem, however if I click on an option button to view another subform I get a messagebox pop up with the following message;

The data has been changed.
Another user edited this record and saved the changes before you attempted to save your changes.
Re-Edit the record.

If I click OK,and without re-editing the record, I can open another subform.
I have checked and the data changes made on frmSubService, in both cases, has been saved.

How do I prevent the pop-up message?

 

[vbaInet]

Something to do with how you've bound the subform and form. Are they using the same Record Source?

 

[Keith]

They are both using the same source

 

[vbaInet]

That's your problem!