want to use a form and have a table field be updated

[jp]

i have 1 table, i want to have a field be input on a form and havbe
anotherfield be calculated..
for example field 1: 'number of items'
on the form i enter 25 inot that field
I want another field on theform: 'total' to be the value entered in
field 1 'number of items' Multiplied by a specifc #

how is the brst way to do this? i tried using the form and field properties
of the field # 2 and expression builder.. but it did not seem to work.. is
there a better way?

 

[Rick B]

Just add an unbound text box to your form. Put the following in it...

= [SomeFieldName] * 1234

enter the field name desired and the specific number desired.

Rick B

 

[Guest]

thanks..
i created an unbound field.. and added this via event builder:
=[Shares Owned]*12.24

where shares owned is a field in the table and form...
i added this on the change.. but nothing seems to happen when i test it..
any thoughts on what i may be doing wrong?
i tried chagning the event to other occasions: on update, on exit ect..but
the value in the unbound text box still shows as 0
i tried the field properties from general and currency neither works..

Just add an unbound text box to your form. Put the following in it...

= [SomeFieldName] * 1234

enter the field name desired and the specific number desired.

Rick B

i have 1 table, i want to have a field be input on a form and havbe
anotherfield be calculated..
for example field 1: 'number of items'
on the form i enter 25 inot that field
I want another field on theform: 'total' to be the value entered in
field 1 'number of items' Multiplied by a specifc #

how is the brst way to do this? i tried using the form and field properties
of the field # 2 and expression builder.. but it did not seem to work..
is
there a better way?

 

[Rick B]

no event. I said....

Just add an unbound text box to your form. Put the following in it...

There is no code involved.

Just paste your formula into the field.


Rick B

thanks..
i created an unbound field.. and added this via event builder:
=[Shares Owned]*12.24

where shares owned is a field in the table and form...
i added this on the change.. but nothing seems to happen when i test it..
any thoughts on what i may be doing wrong?
i tried chagning the event to other occasions: on update, on exit ect..but
the value in the unbound text box still shows as 0
i tried the field properties from general and currency neither works..

Just add an unbound text box to your form. Put the following in it...

= [SomeFieldName] * 1234

enter the field name desired and the specific number desired.

Rick B

i have 1 table, i want to have a field be input on a form and havbe
anotherfield be calculated..
for example field 1: 'number of items'
on the form i enter 25 inot that field
I want another field on theform: 'total' to be the value entered in
field 1 'number of items' Multiplied by a specifc #

how is the brst way to do this? i tried using the form and field properties
of the field # 2 and expression builder.. but it did not seem to work..
is
there a better way?

 

[Guest]

thanks rick its working now.. i appreciate your assistance..

no event. I said....

Just add an unbound text box to your form. Put the following in it...

There is no code involved.

Just paste your formula into the field.


Rick B

thanks..
i created an unbound field.. and added this via event builder:
=[Shares Owned]*12.24

where shares owned is a field in the table and form...
i added this on the change.. but nothing seems to happen when i test it..
any thoughts on what i may be doing wrong?
i tried chagning the event to other occasions: on update, on exit
ect..but
the value in the unbound text box still shows as 0
i tried the field properties from general and currency neither works..

Just add an unbound text box to your form. Put the following in it...

= [SomeFieldName] * 1234

enter the field name desired and the specific number desired.

Rick B


i have 1 table, i want to have a field be input on a form and havbe
anotherfield be calculated..
for example field 1: 'number of items'
on the form i enter 25 inot that field
I want another field on theform: 'total' to be the value entered in
field 1 'number of items' Multiplied by a specifc #

how is the brst way to do this? i tried using the form and field
properties
of the field # 2 and expression builder.. but it did not seem to
work..
is
there a better way?