Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-23-2019, 05:01 AM   #1
Djblois
Newly Registered User
 
Join Date: Jan 2009
Posts: 585
Thanks: 0
Thanked 0 Times in 0 Posts
Djblois is on a distinguished road
Fire Event When Click on Total Row

I am using the Current Event to change the records in another subform as a user clicks on different records in the first subform. However, I want to make it so if the user clicks on the total row then it will show all the data on the other form. Is it possible to know when a user clicks on a total row?


Last edited by Djblois; 07-23-2019 at 05:12 AM.
Djblois is offline   Reply With Quote
Old 07-23-2019, 08:35 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,340
Thanks: 0
Thanked 737 Times in 722 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: Fire Event When Click on Total Row

that would be an ONCURRENT event. when the row changes, see if it is your Total Row.
Ranman256 is offline   Reply With Quote
Old 07-23-2019, 12:37 PM   #3
Djblois
Newly Registered User
 
Join Date: Jan 2009
Posts: 585
Thanks: 0
Thanked 0 Times in 0 Posts
Djblois is on a distinguished road
Re: Fire Event When Click on Total Row

Ranman256, I understand it would be an oncurrent event but how do I determine it is a total row?

Djblois is offline   Reply With Quote
Old 07-23-2019, 01:13 PM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,138
Thanks: 46
Thanked 970 Times in 951 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Fire Event When Click on Total Row

Quote:
Originally Posted by Djblois View Post
Ranman256, I understand it would be an oncurrent event but how do I determine it is a total row?
Hi. Pardon me for jumping in... I just gave it a try and it seems the Current event does not fire by going to the Totals row. Actually, I tried a few other events and none of them fired.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Event Fire Help GendoPose Forms 7 01-10-2014 04:00 PM
Fire Up an Event before it is due FuzMic Forms 5 07-05-2010 02:31 AM
Button Control Click can fire twice ASherbuck Forms 3 07-10-2009 01:35 PM
To fire Double Click event of Subform from Main Form Savita General 2 09-06-2007 05:29 AM
To fire Double Click event of Subform from Main Form Savita Forms 1 09-05-2007 09:26 AM




All times are GMT -8. The time now is 04:27 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World