Delete a record displayed on a continuous form

[Zaeed]

Hey, I have a subform that displays a list of records and i'm trying to figure out how to delete one..

I've setup a delete button that deletes the record from the table, but that doesn't delete the record being shown in the subform, but simply replaces the values with #Deleted


Cheers for your help

 

[dkinley]

You will either need to Me.Refresh or Me.Requery the form after the delete.

-dK

 

[Mike375]

It needs to refresh

If you make a simple macro or code for runcommand SelectRecord, I just use a macro, and then DeleteRecord and put it on either a textbox or buttom on the subform then it will delete the record. Perhaps make it a double click

 

[Zaeed]

Cool thanks for that.. it was requery that did it..

 

[dkinley]

You bet. Good luck!

-dK