i need to add number in existing field when a form open

[Spier2vb]

i need to add number in existing field when a form open

for example

when i open the form automatically add No. 1 and sum numbers in existing field

thanks

 

[Tom van Stiphout]

On Wed, 7 Apr 2010 06:14:01 -0700, Spier2vb

I am not sure exactly what you mean, but perhaps the DSum function
would work for you? Look it up in the Help file. You can use it as the
ControlSource for a textbox:
=DSum(...)

-Tom.
Microsoft Access MVP

 

[KARL DEWEY]

Create an update query -- [YourField] + 1 -- and use OnOpen event to run it.

 

[Larry Linson]

i need to add number in existing field when a form open

for example

when i open the form automatically add No. 1 and sum numbers in existing
field

thanks

I agree with Tom that it's not "patently obvious to the casual observer"
what you want to do. I can see a couple of possible additional
interpretations:

(1) you are keeping track of the number of times the record has been
displayed, so whenever you open the form, you want to increment the value of
a field in the record. If this is the case, in the Form Load event, you can
include code to increment the control in which the field is displayed.

(2) you are keeping some kind of total, and want to enter a number, but add
it to an existing field in the record that is displayed. If this is the
case, add an unbound control to the form, enter the value you wish to add
and in the AfterUpdate or LostFocus event of the unbound control, add the
value of the unbound control to the control displaying the field, then clear
the unbound control.

If neither of those, if you'd clarify what it is you want, I'd wager someone
here could make a useful suggestion.

Larry Linson
Microsoft Office Access MVP

 

[Spier2vb]

thanks to all i solved the problem

 

[Spier2vb]

thank you everyone the problem was solved, and thak you KARL