RE: Write Conflict Errors In Access Form (2000)

Tech-Archive recommends: Speed Up your PC by fixing your registry

The problem is that the first form is still "dirty" when you access the
second form. What you need to do is to set the form to dirty=false when you
want to go to the second form. Ofcourse there's a disadvantage to that
because it will save the record immediately and it could be the case that you
don't want that just yet. In that case you should consider using a .tmp table
but this is far from ideal in this situation. I would go for the dirty=false
option.

hth
--
Maurice Ausum


"SEAN DI''''ANNO" wrote:

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?


.

Quantcast