Delete records on two forms at once

[CanWest]

I need to delete the current records on two different forms. I need to be able to do that from only one of the forms because the second is hidden. I am drawing a blank

 

[vbaInet]

What's the idea behind running two forms in the first place? Are the record sources related via a key?

 

[CanWest]

What's the idea behind running two forms in the first place? Are the record sources related via a key?

They are not related, however they do need to be deleted at the same time as it affects a number of reports. I am working with an existing db that was created by someone else and have to work within those parameters.

 

[John Big Booty]

I would guess that you will need two delete queries, one keyed to each of the forms, using;

Forms!FormName!ControlName

in the criteria, to select the current record in each of your forms.

 

[vbaInet]

For each delete routine, here are the steps I would follow:

Forms("FormName").SetFocus
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.SetWarnings True
Forms("FormName").Requery

Then set focus back to the form you're running the code from.

 

[CanWest]

I would guess that you will need two delete queries, one keyed to each of the forms, using;

Forms!FormName!ControlName

in the criteria, to select the current record in each of your forms.

Thankyou

That worked perfectly