How do make Access beleive there was a change

[Jojomick]

Simple form with 2 textboxes and a «Save» button (button was created using Wizard).

My 2 textboxes already have the values I want to save in a table; but when I click the button, it doesn't register. If I go back to either textbox and change the value, magic !!!, now by pressing the Save button, everything is recorded in the table.

By the way, this form comes from a doucle-click event and the values are set with their «default values» pointing to the parent form's textboxes.

Also, when the form first open, I noticed that the last button on its navbar (the one like >*) indicating you can save the record is inactive.

Is there a way that I can simulate something was changed so I can save the record ??

 

[PaulBricker]

Call the AfterUpdate Event from your Button.
Put something like this before the save code.

Call TextboxName_AfterUpdate()

You may have to trigger both textbox events to get what you need but that may do it.

Paul

 

[Jojomick]

I did what you mentionned but I know get a compiling error saying «Incorrect use of the property».

I also tried this to make Access beleive there was a change in the textbox :

noFam.value = uCase(noFam.value) - it's a number, so no harm done.

Now, when I click the save button, it effectively saves the record. I don't find that «elegant» tough and would like a better way to deal with the problem...

Thanks for any answer I can try.