Data Has Changed - Please Help

[Kenln]

I have several sub-forms on a main form.

I can combine a few but there will still be at a minimum two.

If I edit the records on any of the sub-forms no problem.

When I navigate to another sub-form no problem.

When I edit date on a different sub-form I get a message saying that someone else is editing the record. This is a test db so only I am in it.

I never got this before so I hope it is something simple I over looked???

P.S. Even though the data is on multiple sub-forms it is all from the same table (though the fields are not duplicated). Is this the problem?

How do I supress the error???
How do I not get an error???

Thank you for your help,

After all this you'd think I get the simple stuff right.

 

[Kryst51]

Have you tried requerying your forms on the after update event on your subforms?

Can you post a sample of your db with some dummy info in it?

 

[Kenln]

requery the subforms or mainform or both.

The queries are comming from a remote db so if I have to requery the mainform that could slow things down a lot!!!

 

[Kryst51]

Without actually seeing what's going on, that is only a guess and my only one, play around with requerying see if it fixes your problem.

Concerning the requerying slowing down, I have no idea how to get around that. Maybe someone else will have more ideas.

 

[Kenln]

awesome - thank you.... I requeried the sub-forms (only) on exit and it works great.

Thank you!

 

[Kryst51]

awesome - thank you.... I requeried the sub-forms (only) on exit and it works great.

Thank you!

You are very welcome!