[AccessD] Selected Records on a Continuous Form

Rocky,

    Volatile nature of SelHeight property constitutes a typical hurdle faced in capturing the status of selected records on continuous form. This is because the erstwhile selection as well as the value of SelHeight is lost as soon you click a command button on the form.

    Simplest course of action would be to use bound check box for selecting / de-selecting records.

    If you wish to track the selection status without resorting to bound check box, my sample db named ContFormsKeyNavAndHighLightMultiSelect might be of interest to you. It is available at Rogers Access Library (other developers library). Link - 

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45


    This db demonstrates identification of selected records on a continuous form. Selection of scattered non-contiguous blocks of records is also permitted. ID's of all records selected in current session are displayed in a text box in form footer and remain intact till cleared by double click on any record.

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

  ----- Original Message ----- 
  From: Rocky Smolin at Beach Access Software 
  To: 'Access Developers discussion and problem solving' 
  Sent: Friday, October 24, 2008 21:36
  Subject: [AccessD] Selected Records on a Continuous Form


  Dear List:

  Is there a way to determine which records on a continuous form have been
  selected using the record selector boxes.
   
  For complicated reasons I cannot use the Access delete records thing - had
  to put a 'Delete Selected Record' button on the form.  That works OK and
  through code I delete the selected record and requery the form.
   
  Now the user wants to be able to select multiple records like they could
  before.  I can use my code to delete the selected records if I can determine
  which ones are selected.
   
  But there's not .Selected property I can find for recordsets like there is
  with multi-select list boxes although it appears that you can only select
  contiguous records on a continuous form using the shift key. Control key to
  select non-contiguous forms doesn't seem to to work.
   
  Is there such a property or a way to find out which records have been
  selected?
   
  MTIA
   
  Rocky Smolin