Textbox not uptodate

[stoicy]

Hello

Anybody can help force textbox to be up to date

Sent from my SM-N900V using Tapatalk

 

[essaytee]

Try this:

   'Me.Parent!HeaderTotal = Me.Text22
    Me.Parent.HeaderTotal = Me.Text22

I tested it, had to work my way around the language barrier, but it worked.

 

[essaytee]

As an aside you should get in the habit of giving your controls meaningful names (adopt a naming convention). This is a topic in itself.

 

[stoicy]

As an aside you should get in the habit of giving your controls meaningful names (adopt a naming convention). This is a topic in itself.

Thank you
It was in another language but I try to make it understood

Sent from my SM-N900V using Tapatalk

 

[stoicy]

Try this:

   'Me.Parent!HeaderTotal = Me.Text22

    Me.Parent.HeaderTotal = Me.Text22

I tested it, had to work my way around the language barrier, but it worked.

You mean repeat this code twice (two lines)

Sent from my SM-N900V using Tapatalk

 

[essaytee]

You mean repeat this code twice (two lines)

Sent from my SM-N900V using Tapatalk

No, firstly, the two lines are not the same. The first line is what you wrote and I merely commented it out.

The second line is what I am suggesting you try. It works as I tested it.

 

[stoicy]

No, firstly, the two lines are not the same. The first line is what you wrote and I merely commented it out.



The second line is what I am suggesting you try. It works as I tested it.

Are you sure it is working?

I try it but nothing changed

Sent from my SM-N900V using Tapatalk

 

[essaytee]

Are you sure it is working?

I try it but nothing changed

Sent from my SM-N900V using Tapatalk

Ok, make sure that you enter all the necessary data into your subform. Your ProdID (the last column) needs to be entered. The error message is because that piece of information is not entered.

You also need to address your order of data entry columns, it's all over the place and that makes it even harder when I can't make head nor tail of the language, I can only guess what the data should be.

 

[essaytee]

Ok, the underlying problem was that the ProdID was not being entered and is required in the subform. I re-checked the AfterUpdate event and your original statement, using the bang operator does work.

In my haste to offer a solution, I changed the bang operator to the dot notation, spent some time working out your subform and underlying tables and got it to work, even accounting for all the labels in a foreign language. I failed to mention the ProdID aspect, sorry.

 

[stoicy]

Ok, the underlying problem was that the ProdID was not being entered and is required in the subform. I re-checked the AfterUpdate event and your original statement, using the bang operator does work.



In my haste to offer a solution, I changed the bang operator to the dot notation, spent some time working out your subform and underlying tables and got it to work, even accounting for all the labels in a foreign language. I failed to mention the ProdID aspect, sorry.

Thank you so much for such effort
I really appreciated

Thanks for all members in this great forum



At last it is solved
I read about Requery, refrish and recalc


I put the below code in the subform after update and it working perfectly.

Me. Recalc



Thank you all again [emoji173]


Sent from my SM-N900V using Tapatalk