errors on sutotal on subform (1 Viewer)

S

SamSquirrel

New member

Local time

Today, 00:35

Joined

Jul 10, 2018

Messages

2

• Jul 10, 2018

• #1

Hi, I've been trying to create a simple invoicing database. I followed some youtube video and seemed to get on quite well.

although now my subtotals are giving errors?

I've uploaded some screen shots .

any help would be appreciated

Many Thanks

 

Attachments

• subtotal Error.zip

  299.3 KB · Views: 153

bob fitz

AWF VIP

Local time

Today, 00:35

Joined

May 23, 2011

Messages

4,721

• Jul 10, 2018

• #2

Create a calculated field for each of the required totals in the query used as the forms record source. Use these fields as the Control Source for the text boxes on the form.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 07:35

Joined

May 7, 2009

Messages

19,230

• Jul 10, 2018

• #3

1. rename your textbox. don't use the name of the Field, eg: txtSum
2. Use DSum() with Form's textbox as criteria.