Controls sohws #deleted

[Alu_GK]

Hello -
Vista, Access 2003.
I'm using form A to find a record and open its full details in form B.
In Form A - there is a sub-form (datasheet) with the table info (example -
contacts).
I have a button that opens Form B according to the record selected in the
sub-form in form A.
After form A "calls" form B, it closes.
Form B opens and shows full details on the contact required.
In form B I have an option (button) to delete the Contact chosen.
After the deletion is made (with command - RunCommand acCmdDeleteRecord),
Form B is closed and Form A is re-open.
In form A (after the deletion) - The record that was previously shown, and
now was deleted, is shown as "#deleted" in all controls.
How can I make this record disappear from the sub-form, and not to be shown
as "#Deleted".

 

[bhicks11 via AccessMonster.com]

What record do you want to be on?

Bonnie
http://www.dataplus-svc.com

 

[Linq Adams via AccessMonster.com]

The fact that the controls are all showing

#Deleted

indicates that the Record Source for the form hasn't been requeried since
the delete was done. But this makes no sense, from what you've posted. You
state

After form A "calls" form B, it (Form A) closes.

After the deletion is made...Form B is closed and Form A is re-opened.

If Form A is re-opened ***after*** the delete, it's Record Source would have
been queried anew, and the #Deleted shouldn't be there! Are you sure you're
closing Form A and not just hiding it by making it invisible?

 

[Alu_GK]

Hello -
The problem was resolved when i created a procedure me.Requey o the Load
Event (instead of doing it in the "Open" event), It is only make sence...
That was the Solution for it.
Thanks