[AccessD] Trapping Events In A Class (custom events as wellas built-in)

A.D. Tejpal adtp at airtelmail.in
Mon Aug 13 07:03:50 CDT 2012


Robert,

    Could you kindly explain further? 

    In the upper subform, there is an option group with three toggle buttons. Combo box row source depends upon the status of option group. 

    If option group selection is either of first two buttons, the combo box acts as a filter for the category specified by option group. For example, for first button of option group, combo box drop down list displays author names and filter gets applied as per author selected. Similar action is performed for Topic, if option group selection happens to be the second button.

    On the other hand, if third button of option group is clicked, all filters get cleared and the role of combo box gets transformed to that of a search box. On selection of desired BookID, the form navigates to corresponding record in both subforms. As an added convenience, the destination record in bottom subform gets positioned at middle of datasheet display window.

    Note: The sample is developed on Access 2003 (Win XP).

Best wishes,
A.D. Tejpal
------------
  ----- Original Message ----- 
  From: Robert 
  To: 'Access Developers discussion and problem solving' 
  Sent: Monday, August 13, 2012 16:53
  Subject: Re: [AccessD] Trapping Events In A Class (custom events as wellas built-in)


  Just a note:

    If you click on the "filter" button on the upper form, it breaks the
  synchronization between the 2 forms. I have not had a chance to investigate
  as I'm heading out the door.

  WBR
  Robert
       

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
  Sent: Monday, August 13, 2012 4:18 AM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Trapping Events In A Class (custom events as well as
  built-in)

  J.C.,

      Further to my previous post, sample db named Form_SplitFormSimulated,
  incorporating the concepts discussed so far under this thread, is now ready
  and has been placed at Rogers Access Library. It is in access 2000 file
  format and can be downloaded at the following Link:
  http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45

      A copy of explanatory notes accompanying the sample db is placed below,
  for ready reference. Interested members of this forum might like to test it
  and advise whether anything needs further attention.

  Best wishes,
  A.D. Tejpal
  ------------


More information about the AccessD mailing list