How to Calculate SubForm`s Fields

  • Thread starter Malik via AccessMonster.com
  • Start date
M

Malik via AccessMonster.com

Hi,

I have a Form with a SubForm in DataSheet View. As we enter the data into
fields it starts inceraasing the fields.

I want to do the sum of Whole Column as it increases, and I want to add som
other fields in it.

Thanks.
 
L

Larry Linson

Instead of Datasheet View, create a continuous forms view Form to embed in
your Subform.

I don't understand what you mean by "As we enter the data into fields it
starts inceraasing the fields." nor "I want to do the sum of Whole Column as
it increases, and I want to add som other fields in it." Could you clarify?

Larry Linson
Microsoft Office Access MVP
 
J

John W. Vinson

Hi,

I have a Form with a SubForm in DataSheet View. As we enter the data into
fields it starts inceraasing the fields.
Click to expand...

This is a misfeature of datasheets. Somebody at Microsoft had the silly idea
that when you enter a number in a field in one record you'll want it to
increment in the same field in the next record. Usually you don't, but there's
no way to turn it off.

What you can do is change from Datasheet view to Continuous Form view (you can
make them look very similar if you wish). A continuous form doesn't do this.
I want to do the sum of Whole Column as it increases,
Click to expand...

You can't in a datasheet; but you can easily in a Continuous Form. Make the
form Footer visible using the View menu option, and put a textbox on it with a
control source

=Sum([fieldname])
and I want to add som
other fields in it.
Click to expand...

Not sure what you mean by that! Please explain.
 
M

malik via AccessMonster.com

Ok

Now please tell me that how to creat a Continuous Form .

Thanks
 
J

John W. Vinson

Ok

Now please tell me that how to creat a Continuous Form .

Thanks
Click to expand...

Open your current datasheet form in Design view.
View its Properties.
Set the "Default View" property to Continuous Forms.

You'll probably want to rearrange the textboxes and other controls on the form
so that they're side by side, jammed together, and dragged up to the top of
the form design window; then drag the bottom of the section up to the bottom
of the controls. This will show one record per line on the screen.
 
Top