Records disappear in a subform!!!

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

I'm going nuts here!!! (nothing new there then)
I've got a subform that has a delete button next to each
record (in the Detail Section).
When users click on it, they're asked if they want to
continue and if they click OK it deletes the record in
focus. Well it does this BUT SOMETIMES the remaining
records within the subform disappear. It's not that you
have to scroll back up to find them, they've gone from the
subform completely! They haven't been deleted either as
when you open the form again they show.
I'm trying to find a consistent case where it does this
and I sort of have a feeling that it's when I've just
added a new record and then go on to delete an earlier
record. Why? Could it be that the field that binds the
subform to the main form isn't saved properly and
therefore it can't display the remaining
records....waffle, waffle?
I've put DoCmd.Save at the beginning of the
BeforeDelConfirm event but that doesn't help.
I do hope you can come up with something before I go
completely bonkers!
Thanks (as always)

Lee
 
After you issue the DELETE you must do a Requery/Refresh on the subform to
make the subform display what is really there. Additionally you may like to
re-position the selected record, if any, in the subform as the
Refresh/Requery will automatically set the selected record back at row 1
HTH
Terry
 
Back
Top