I have a main form - continuous - from which on each detail record the user can click a Form Operations command to open a pop-up form to do maintenance on the record. On the pop up form, I have a delete button. After the user deletes the record and is returned to the main form, I'd like there to be an automatic requery - thus getting rid of the deleted record - which still can be seen as 'deleted'. I've tried half a dozen events and can't seem to find the right one. Can anyone help?

Nanner,

Try this in your AfterUpdate Event:

DoCmd.RunCommand acCmdRefreshPage

good luck,

Aqua

Sorry, no - didn't work. Thanx just the same, though.

I should mention - on the main form, I have a command button that does run the requery for me - but I'd like to automate it after maintenance is done rather than have the user have to use the button.

Before your "pop up" form closes by adding this to the "On Close" Event:

Forms![MainFormName].Requery

Nanner,

Have you tried putting the call to Me.Requery on the 'Close' of the pop-up?

I used that function on a delete button I have in a continious subform and it works ok here.

Aqua

Thanx, Boyd! That was the ticket!

Thanx to you too, Aqua!

You're welcome.

Glad we could assist you.