From: Cathy on
In Access 2007, I have a continous form, and I only want to update the row
total of the record I am on. How do I update only the one row total, and not
all row totals?

Thank you,
From: John W. Vinson on
On Wed, 7 Apr 2010 13:37:01 -0700, Cathy <Cathy(a)discussions.microsoft.com>
wrote:

>In Access 2007, I have a continous form, and I only want to update the row
>total of the record I am on. How do I update only the one row total, and not
>all row totals?
>
>Thank you,

What is a "row total"? That's not an Access construct; it would seem to be
something you've added. And if it's a calculated field based on values in the
record, what do you mean by wanting to update it? Do you mean that you want to
have 2 + 2 equal to 4, except sometimes you want to have it equal to 13
instead???
--

John W. Vinson [MVP]
From: Cathy on
John,

I know this sounds unusual. Yes it is a created total on the row. They
want the amount to update only if approved. They do not want all rows to
update. Just the one they are approving, when they are approving it.

How do I go about doing this?

Thank you,
Cathy

"John W. Vinson" wrote:

> On Wed, 7 Apr 2010 13:37:01 -0700, Cathy <Cathy(a)discussions.microsoft.com>
> wrote:
>
> >In Access 2007, I have a continous form, and I only want to update the row
> >total of the record I am on. How do I update only the one row total, and not
> >all row totals?
> >
> >Thank you,
>
> What is a "row total"? That's not an Access construct; it would seem to be
> something you've added. And if it's a calculated field based on values in the
> record, what do you mean by wanting to update it? Do you mean that you want to
> have 2 + 2 equal to 4, except sometimes you want to have it equal to 13
> instead???
> --
>
> John W. Vinson [MVP]
> .
>
From: John W. Vinson on
On Wed, 7 Apr 2010 16:31:02 -0700, Cathy <Cathy(a)discussions.microsoft.com>
wrote:

>John,
>
>I know this sounds unusual. Yes it is a created total on the row. They
>want the amount to update only if approved. They do not want all rows to
>update. Just the one they are approving, when they are approving it.
>
>How do I go about doing this?

I don't know, because I still have no idea what the "total row" is or how
you're calculating the total, nor what the "update" might involve. More info
please? What's the control source of the "created total" control?

--

John W. Vinson [MVP]
From: Cathy on

John,

The continous form shows one record (row) per section. The total is a
field, per section that needs approval (flag) before it can be updated. I've
tried creating an if statement ( if approval = "Y" then sum(a+b)), but it
keeps updating all records... not just the record that I am on.

What can I do to have it only update the record that I am on?

Thank you again,

Cathy
"John W. Vinson" wrote:

> On Wed, 7 Apr 2010 16:31:02 -0700, Cathy <Cathy(a)discussions.microsoft.com>
> wrote:
>
> >John,
> >
> >I know this sounds unusual. Yes it is a created total on the row. They
> >want the amount to update only if approved. They do not want all rows to
> >update. Just the one they are approving, when they are approving it.
> >
> >How do I go about doing this?
>
> I don't know, because I still have no idea what the "total row" is or how
> you're calculating the total, nor what the "update" might involve. More info
> please? What's the control source of the "created total" control?
>
> --
>
> John W. Vinson [MVP]
> .
>