G
Guest
I'm using Access 2003 and Windows XP. I would like to use an unbound main
form, with buttons, such as Add, Delete. The main form will have a datasheet
subform that is bound to a table.
I would like to code the delete button to delete the current record in the
subform. The user should be prompted if that want to delete the record(s).
Also, since the table is a parent of records in other tables, I would like to
inform the user if the record cannot be delete, since is it being referenced
by another table. I don't want to do a cascade delete.
Could someone help me with the coding to accomplish this task? Thanks.
form, with buttons, such as Add, Delete. The main form will have a datasheet
subform that is bound to a table.
I would like to code the delete button to delete the current record in the
subform. The user should be prompted if that want to delete the record(s).
Also, since the table is a parent of records in other tables, I would like to
inform the user if the record cannot be delete, since is it being referenced
by another table. I don't want to do a cascade delete.
Could someone help me with the coding to accomplish this task? Thanks.