Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-16-2018, 03:14 PM   #1
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 430
Thanks: 19
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
SubForm click event

Is there a click event for a datasheet view subForm ?
I've tried the Current event and that runs once, but I would like to catch every click anywhere on the Form.

kirkm is offline   Reply With Quote
Old 05-16-2018, 03:23 PM   #2
ridders
Part time moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,806
Thanks: 79
Thanked 1,430 Times in 1,335 Posts
ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice
Re: SubForm click event

Did you look in the property sheet - if you had done so the answer would be clear - YES

However that event will only be triggered by clicking on the borders of the form/subform
i.e. headers/form control at top left/record selectors
If you click anywhere else, you are clicking in the fields
So how useful that is will depend on what you want it to do
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

New example databases:

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.
,
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.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
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.

-----------------------------------------------------------------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
Old 05-16-2018, 03:31 PM   #3
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 430
Thanks: 19
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: SubForm click event

Thanks Colin, yes of course I looked but this is not my db and is quite complex.
Sounds like it won't do what was hoped for, so will keep the click event in the most obvious field.

kirkm is offline   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
Subform double click record event Ben5505 Forms 6 06-15-2012 01:34 PM
To fire Double Click event of Subform from Main Form Savita General 2 09-06-2007 05:29 AM
Subform Click Event Dudley Forms 2 03-17-2006 11:01 PM
Filter Subform with an On Click Event Elana Forms 1 05-06-2002 04:49 PM
Click event for a subform Atomic Shrimp Forms 3 09-23-2001 02:12 PM




All times are GMT -8. The time now is 03:30 AM.


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

Sponsored Links

How to advertise

Media Kit


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