erase a record in a subform

[craw]

I have looked through several posts but can't seem to find exactly what I am looking for.

I have a subform in datasheet view and would like to erase just one of the records. I would like to put a command on click event on the main form that will erase this record when highlighted. The database will be split and in a multi-user environment and will have all buttons, menus, rt-ckick menus, etc. stripped out.

any ideas?

 

[Pat Hartman]

The problem with putting the button on the main form is that it is confusing. It looks like it is the main form record that should be deleted. I would use the built in functionality of Access forms. Let the user click the record selector in the subform and then press the delete key.

 

[craw]

Pat,
I agree with the confusing part. I was only concerned that after I split the database and removed all the menu functions that the highlight and delete function would not work. But I just did a mini beta test and all is well...

Thanks for your help.