X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Total Row In Datasheet Subform Not Updating, Access 2016    
post Jan 6 2020, 03:47 PM

Posts: 226
Joined: 4-February 04

Hey all,

- I have a datasheet subform with a totals row that displays an order summary. Sum of Cost is calculated.
- Form/Subform joins on Order Date and Order ID
- There is a 1-many relationship between Order ID and Ticket ID

The Totals row calculates and displays correctly for the first Ticket ID in an order, but the total disappears if there is a second ticket in the order.

See attached files.

Note that the total displays properly as 13.00 on the first record where Ticket ID=1, but does not display in the second record where Ticket ID=2.

This appears to be a refresh issue because if I navigate to the next record on the form and come back to Order ID=2, Ticket ID=2, the total displays properly. If I then click back to Order ID=2, Ticket ID=1 the total disappears again.

I've tried various requery and refresh tests and can't find the correct code to execute in the correct event to refresh this.

Any thoughts - thank you!

Attached File(s)
Attached File  Image1.jpg ( 90.26K )Number of downloads: 12
Attached File  Image2.jpg ( 90.04K )Number of downloads: 11
Go to the top of the page
post Jan 23 2020, 01:34 AM

Posts: 71
Joined: 10-January 13

in the event use clear record before when you update/insert to order id 2.
Go to the top of the page
post Jan 23 2020, 08:12 AM

Posts: 4,665
Joined: 11-November 02

I'm not following your narrative real well (probably me...no coffee yet!) and the images aren't clear (images are seldom really helpful in our figuring out what's wrong...a copy of the file is really what is needed) but to 'refresh' calculations, the proper command is Me.Recalc.

Linq ;0)>

BTW...The Monkey is laughing at me...not at any other poster!

The problem with making anything foolproof...is that fools are so darn ingenious!

All posts/responses based on Access 2003/2007
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    19th February 2020 - 08:05 AM