I have a form which loads/saves data to 3 differnet tables via tab forms. I have a button which deletes the selected record from these tables. The problem is that when i click on the delete button, it only deletes the record from the tab that has the focus....where i want to delete fromall the tabs.....Any ideas?

Depending on how the data is bound to the tabs, I think you'll find that you have to run some VBA code on the delete event for the data (or create a command button) that deletes the records in the other tables.

DS