[AccessD] Datasheet field

Lonnie Johnson prodevmg at yahoo.com
Fri Feb 13 08:43:36 CST 2004


If you have a knowledge of vba you could store the name of the subform field in a global variable in the field's On Click event and pass that back to the main form to do what ever processing you need to do. 

rsmethurst at uk.ey.com wrote:
Hi All,

I'm looking to populate a subform based on the selection a user makes in a
form above it. But not by the row, by the actual field. (This was
previously donw with labels and hyperlinks, but now the no of records can
vary)

Is there an easy/(ish) way to capture what 'cell' has been clicked in the
datasheet, or would a continuous form be better suited to this?
(I'm dealing with unbound forms here)

TIA
Ryan



This e-mail and any attachment are confidential and contain proprietary information, some or all of which may be legally privileged. It is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient, please notify the author immediately by telephone or by replying to this e-mail, and then delete all copies of the e-mail on your system. If you are not the intended recipient, you must not use, disclose, distribute, copy, print or rely on this e-mail.

Whilst we have taken reasonable precautions to ensure that this e-mail and any attachment has been checked for viruses, we cannot guarantee that they are virus free and we cannot accept liability for any damage sustained as a result of software viruses. We would advise that you carry out your own virus checks, especially before opening an attachment.

The UK firm Ernst & Young LLP is a limited liability partnership registered in England and Wales with registered number OC300001 and is a member practice of Ernst & Young Global. A list of members? names is available for inspection at 1 More London Place, London, SE1 2AF, the firm?s principal place of business and its registered office.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us




 




---------------------------------
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online


More information about the AccessD mailing list