Access 2000 : Cannot see selected form records (seltop, selheight)
Posted on 2003-12-01
I want a form button to process the (more than one) rows selected by the mouse on the record selector at left of form.
However when the button shows me the following (on button Click event):
MsgBox "form.selheight=" & Me.SelHeight & " form.seltop=" & Me.SelTop
the SelHeight is reported as zero (as if the selection has lost the focus has been taken from the multple selection) even though I selected 2 or more records.
The same happens when
1/ button Enter event (ie before it has focus) is used
2/ the button is in a subform referencing Me.Parent.sel___ )
Any ideas how my code can "see" the selection ?