Deterimining records selected for deletion

G

Guest

I am trying to determine the number of records selected for deletion before the Delete Confirm dialog box is displayed

In single form view records will be selected by Select All Records and then Delete on edit menu or for one record just Delete Record on edit menu. In datasheet view records to be deleted will be highlighted and from edit menu Delete Record

Is there a property of the form that stores this information

Thanks for any assistance.
 
M

Malcolm Cook

Try doing maths on the .seltop and .selheight properties of the active form

Note that these properties will not be correct if the focus has moved away
from the rows, such as would be the case if you were deleting using code
behind a button (since the focus has moved to the button). For this reason,
do the delete using code behind a menu pick or a command bar (or contrive to
remember the .seltop and .selheight in your module level globals - yuck).


--
Malcolm E. Cook
Stowers Institute for Medical Research


KC said:
I am trying to determine the number of records selected for deletion
before the Delete Confirm dialog box is displayed.
In single form view records will be selected by Select All Records and
then Delete on edit menu or for one record just Delete Record on edit menu.
In datasheet view records to be deleted will be highlighted and from edit
menu Delete Record.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top