Form control

[mbynoe via AccessMonster.com]

Hello..I have a form that has 2 bound controls, what I need is to be able to
input the new totals in a text box and click update and have the table to be
updated with the new totals. However, I would like to see the old totals and
the new totals on the form.

When I click to open the form...I want to see the 2 current totals and I want
2 text boxes where I can make changes to the current totals and click update
to update the underlying table.

Thanks!

 

[Larry Daugherty]

That seems unusual but here goes ...

Keep your original text boxes (1 & 2) as bound controls.

Create two new text boxes (3 & 4) as unbound controls.

In the BeforeUpdate event of your form put the following code,
modified to show your actual control names:

me!txt1=me!txt3
me!txt2=me!txt4

HTH

 

[mbynoe via AccessMonster.com]

Thanks!

That seems unusual but here goes ...

Keep your original text boxes (1 & 2) as bound controls.

Create two new text boxes (3 & 4) as unbound controls.

In the BeforeUpdate event of your form put the following code,
modified to show your actual control names:

me!txt1=me!txt3
me!txt2=me!txt4

HTH

Hello..I have a form that has 2 bound controls, what I need is to be able to
input the new totals in a text box and click update and have the table to be

[quoted text clipped - 6 lines]

Thanks!