After a field is changed another must be changed as well

[Petefured]

Dear All,



I have a form with various fields.
I would like that if I change one of the text fields (it does not matter to what I change it to, just simply change it) another field must also be changed, otherwise the record will not be updated

So eg. if I change the Comment field, I would need to change the Date field as well, otherwise I cant move to the next record

Many thanks in advance!

[ansentry]

So eg. if I change the Comment field, I would need to change the Date field as well.

Change it to what?

[Petefured]

It does not matter to what it is changed, anything can be written there, the point is that it gets changed

Thank you!

[ansentry]

Is this what you mean.

(A) If the "txtThisField" is changed you want the txtMyDate to be updated with the current date or date & time automatically?

or

(B) Do you want a message box to appear asking the user the make the change to the date field?


(C) I missed the point of the post?

You state:

anything can be written there, the point is that it gets changed

You can't write "anything" in a date control.

[Petefured]

B) after TxtField is changed and user should not be able to proceed until DateField is filled in (with anything)

Many thanks

[ansentry]

B) after TxtField is changed and user should not be able to proceed until DateField is filled in (with anything)

That is fine if the txtField is changed but what about when data is first entered,do you want the user to enter a date in the date field?

As I said before access will not let you enter "anything" in a control formatted for date.

I have attached a sample that require the date be entered EVERYTIME that data is entered or changed in the txtField.

I think that you can take it from here.

[Petefured]

This is just what I needed!!

Thank you very much for your help!!

[RuralGuy]

So Petefured, is it time to use the link in my sig?