increment from different fields

  • Thread starter Thread starter Squibbly
  • Start date Start date
S

Squibbly

is it possible to increment a field value from a different form
what i want to do is increment a field value in one form which will also
increment another field value in another field automatically either through
vba or SQL??
 
Why? As in "what will doing this allow you to accomplish?" A bit more
explanation of what you are trying to accomplish (rather than "how") would
give us more to go on.

And a description of what you are trying to accomplish gives the readers the
chance to offer alternative approaches.
 
Provided both forms are (guaranteed to be) open at the same time, you
can address any control on either of them from the other, e.g.:

Forms!frmMyOtherForm!ctlOtherFormControl.Value

As Jeff says, however, telling us a little more about what you are
trying to do may help us help you more effectively, since it is not
obvious why you would want to do what you say you are trying to do.

is it possible to increment a field value from a different form
what i want to do is increment a field value in one form which will also
increment another field value in another field automatically either through
vba or SQL??
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
what i am trying to do increment or decrement a field that contains a
number, obviously, dont worry im not being sarky, what this field contains
is a whole number that is not currency

GS is goals scored
GA is goals against

both fields are contained in two different tables and i want to
increment/decrement both fields, where applicable, using a form that the
source is from one table

if you dont get me let me know plz
 
I think we both meant "what you are trying to do" at a somewhat deeper
level! An outline of the "business purpose" of the database and form
is almost always useful. The rest of my response should (hopefully)
have helped you.

what i am trying to do increment or decrement a field that contains a
number, obviously, dont worry im not being sarky, what this field contains
is a whole number that is not currency

GS is goals scored
GA is goals against

both fields are contained in two different tables and i want to
increment/decrement both fields, where applicable, using a form that the
source is from one table

if you dont get me let me know plz
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top