Data undo problem

[deepaksharma]

The problem is that you are setting the offer date in code, which instantly dirties the record.
There are a host of other things that aren't correct but that is causing most of your issues. Just put in Date() in the default value of the control, that doesn't dirty the record when you go to a new one.

Also, please please please give your controls meaningful names. txt1, txt 2 txt133 mean absolutely nothing, and make debugging a nightmare.

I have removed the coding of offer date but still the problem is same and please tell where to set the "date()"

[Minty]

In the default value of the Offer Date control.

[deepaksharma]

In the default value of the Offer Date control.

Ok but my problem is still

[deepaksharma]

In the default value of the Offer Date control.

As soon as you fill fields other than txt2 and close the form and select no, an error box appears.

[Welshgasman]

You have not learnt anything have you?
Why not say what the error message is?

Trying to help you is like trying to get blood from a stone.

[deepaksharma]

You have not learnt anything have you?
Why not say what the error message is?

Trying to help you is like trying to get blood from a stone.

Sir, I have attached the error message several times. please check

[deepaksharma]

same message is coming even after deleting the record set.

check also...

[Welshgasman]

Sir, I have attached the error message several times. please check

You never said it was the same error message? Even that would have helped.

[deepaksharma]

You never said it was the same error message? Even that would have helped.

maybe there is a lack of understanding between us... sorry for that.

[Welshgasman]

maybe there is a lack of understanding between us... sorry for that.

Yes, likely on my side , so I will step away.

[deepaksharma]

Yes, likely on my side , so I will step away.

no no no please..

[deepaksharma]

Sir, I have attached the error message several times. please check

Can anyone tell me why this error is coming?

[Minty]

Because something in your code is making alterations to the record, that are dirtying the record, that you are then trying to save after making other changes.
In the example you posted setting the date field in code was dirtying the record, then you are trying to undo the changes after making other changes to the forms data, but you validation is stopping it.

There is something else going on though as the cancel method in the forms before event is undoing all the data entered, and it shouldn't do that, it should simply prevent you from saving the data.

[deepaksharma]

Because something in your code is making alterations to the record, that are dirtying the record, that you are then trying to save after making other changes.
In the example you posted setting the date field in code was dirtying the record, then you are trying to undo the changes after making other changes to the forms data, but you validation is stopping it.

There is something else going on though as the cancel method in the forms before event is undoing all the data entered, and it shouldn't do that, it should simply prevent you from saving the data.

But I did not find anything like this in it, so I created another sample program. You can see in it that if the program is closed after entering data in other fields except the BB field, then the same error occurs.

[mike60smart]

Hi Deepak

It works for me.

I corrected the relationships as you had not put an Autonumber in Table2
I also modified the Autonumber fields from ID to Table1ID and Table2ID