Refresh of data on Form

[ic_fish via AccessMonster.com]

I am not a programmer as such (Business bod !!) but can use the basic
features of access.

So, I know that pressing F5=Refresh and I could fix this issue with a cmd
button. But, I think I can resolve this with some type of user exit.

In a form, I have a formula based on 4 variables. The output is MT (i.e.
Metric Tonne). SQty is a value, say 100 x 0.8 (specific gravity) x Frequency
etc. The issue is that if I change the SG figure, after update, the MT figure
recalculates instantly. Where as a change to SQty, FreVal require a manual F5
to trigger the change.

=(([SQty]*[SG])*[FreVal])/[UnMu]

I have tried adding RunCommand [Refresh] as a macro on "after update but it
doesn't work. If relevant, the FreVal and UnMU are indexed back to "hard
numbers". i.e. the user sees KG, where as UnMu is the actual number tied to
KG.

Any help would be really appreciated, thanks

Ian

 

[bhicks11 via AccessMonster.com]

Use Me.control.requery in vba or macro.

Bonnie
http://www.dataplus-svc.com

I am not a programmer as such (Business bod !!) but can use the basic
features of access.

So, I know that pressing F5=Refresh and I could fix this issue with a cmd
button. But, I think I can resolve this with some type of user exit.

In a form, I have a formula based on 4 variables. The output is MT (i.e.
Metric Tonne). SQty is a value, say 100 x 0.8 (specific gravity) x Frequency
etc. The issue is that if I change the SG figure, after update, the MT figure
recalculates instantly. Where as a change to SQty, FreVal require a manual F5
to trigger the change.

=(([SQty]*[SG])*[FreVal])/[UnMu]

I have tried adding RunCommand [Refresh] as a macro on "after update but it
doesn't work. If relevant, the FreVal and UnMU are indexed back to "hard
numbers". i.e. the user sees KG, where as UnMu is the actual number tied to
KG.

Any help would be really appreciated, thanks

Ian

 

[ic_fish via AccessMonster.com]

Bonnie,
Hi, thanks for the reply, but cannot see how to get the macro going. I know
how to reach them, but there is an action and an argument. How would your
fix fit into that?

Could you provide a little more detail, thanks

Ian

Use Me.control.requery in vba or macro.

Bonnie
http://www.dataplus-svc.com

I am not a programmer as such (Business bod !!) but can use the basic
features of access.

[quoted text clipped - 18 lines]

Ian

 

[ic_fish via AccessMonster.com]

Bonnie,
All sorted now - all I did was select "requery" in the macro box, everything
now changes in an instant.

many thanks for your help

Ian

Use Me.control.requery in vba or macro.

Bonnie
http://www.dataplus-svc.com

I am not a programmer as such (Business bod !!) but can use the basic
features of access.

[quoted text clipped - 18 lines]

Ian