Textbox not uptodate

[stoicy]

Hello everybody

I have below code in subform after update:

Me. Parent! HeaderTotal=Me.Text22

I realized it update the records in subform except the last record!

How to make it refrished and uptodate after each record addition!

Thank you

 

[theDBguy]

You'll have to force a save of the record. Otherwise, while the record is still in edit mode, it might not reflect the changes yet.

 

[stoicy]

You'll have to force a save of the record. Otherwise, while the record is still in edit mode, it might not reflect the changes yet.

How to force it?

Sent from my SM-N900V using Tapatalk

 

[theDBguy]

I tend to use something like:

If Me.Dirty Then Me.Dirty=False

Other methods are also available, like macro actions.

 

[stoicy]

I tend to use something like:

If Me.Dirty Then Me.Dirty=False

Other methods are also available, like macro actions.

Nothing changed

Sent from my SM-N900V using Tapatalk

 

[theDBguy]

Okay. Instead of that, try Me.Recalc.

 

[missinglinq]

You have to force the save, as said, but you have to do it before the assignment:

If Me.Dirty Then Me.Dirty = False
Me.Parent!HeaderTotal=Me.Text22

Linq ;0)>

 

[stoicy]

You have to force the save, as said, but you have to do it before the assignment:

If Me.Dirty Then Me.Dirty = False

Me.Parent!HeaderTotal=Me.Text22

Linq ;0)>

Nothing changed [emoji53]


Sent from my SM-N900V using Tapatalk

 

[theDBguy]

Nothing changed [emoji53]

Even the one I suggested last?

 

[stoicy]

Even the one I suggested last?

Yes

Sent from my SM-N900V using Tapatalk

 

[theDBguy]

Yes

It might be time for you to consider posting a sample db, so we can get to the bottom of the problem sooner. Just a thought...

 

[stoicy]

It might be time for you to consider posting a sample db, so we can get to the bottom of the problem sooner. Just a thought...

OK my friend I will try by tomorrow
Appreciated your help

Sent from my SM-N900V using Tapatalk

 

[stoicy]

I can't upload the file here

Please see this link

https://drive.google.com/file/d/1Qz24SNij8dSf44-yQvHud-tEKq4h-l-y/view?usp=drivesdk

 

[stoicy]

Anybody can help.. Please

Sent from my SM-N900V using Tapatalk

 

[Gasman]

Version later than I can run.
However you might want to put '

Option Explicit

in all your forms, or set in Tools/Options in the VBA window
https://www.fmsinc.com/microsoftaccess/modules/options/index.html#OptionExplicitDefault

Also you can upload here, just zip it first (Right click file in explorer and Send To/Compressed (zipped) folder

 

[stoicy]

Version later than I can run.

However you might want to put '

Option Explicit

in all your forms, or set in Tools/Options in the VBA window

https://www.fmsinc.com/microsoftaccess/modules/options/index.html#OptionExplicitDefault



Also you can upload here, just zip it first (Right click file in explorer and Send To/Compressed (zipped) folder

I change every form to
Option Explicit

But nothing happened

Sent from my SM-N900V using Tapatalk

 

[Gasman]

No, I was not suggesting that would fix the problem, that involves code, but it will prevent further errors down the road.

Also you can now upload the DB. Most people are not prepared to download from external sites, and it is you that needs the help.?

 

[stoicy]

No, I was not suggesting that would fix the problem, that involves code, but it will prevent further errors down the road.

Also you can now upload the DB. Most people are not prepared to download from external sites, and it is you that needs the help.?

Thank you Gasman

I try from Yesterday to upload it but all the time rejected while it is rar format
So the only link is that I put in Google drive

Sent from my SM-N900V using Tapatalk

 

[Gasman]

You need zip format.?
One time only

 

[stoicy]

At last

Please find attached