Write COnflict Error in Access 2000

[diannosd]

Hi...feel a little out of my depth here.

I have a form based on a table called prospects.
It has information such as Company, Address, Postcode etc. The key field is prospect No

On the same form, I have a sub form over the top, called Town_View.
this form also has the same data source of Prospects.

On this form, It shows just the company name and town but in a bigger font. At the bottom of the form there is a toggle button so that the user can wither see the address in a full view or town view. (This is setting the scene for my problem).

if I click to the main form and change data I have no problems,
if I click on the Town Viw Sub (form which is the start up view. When I make changes to the fields etc, I get a write conflict error when I try and leave the record. i.e. Save, Copy Drop Changes.

I know the problem is that I have two forms both ref. the same data set and fields (I assume) and need some kind of Temp. copy of the record if Im working in a town view mode but am not sure how to go about this or how to update the main prospect record afterwards. Can some one help me please?

 

[LynnEsther]

Seems like you should only allow your users to update one part of the form or the other, not both. For example, have them update the full address. The toggle button could then display the town info. You write a query that displays all companies with the same town that is on the current record of the main form. This new query would go behind your subform. Again, though, the key is to only update the data in one place.