Error message in a sub form

[Alu_GK]

Hello –
I'm using a form to filter a list, and from it to go to a detailed form.
Form A – Is a list of facilities, with filter options. Unbound form with a
sub-form that shows the facility list.
Form B – Facility full details.
After I delete a Facility in Form B, I return automatically to Form A, but
the problem is that in form A the record that was deleted, is shown now as
"#Deleted", and I want it to disappear.
I tried to do all kind of re-queries, and refresh action in all kind of the
sub-form and the form events, and it seems that I'm in the wrong direction.
Please – Help…
Thanks.

 

[Maurice]

It sounds that Form B isn't actually closed so put the focus on form A first
and then perform the requery. So it could look something like:

forms!formA.setfocus
forms!formA.requery

hth

 

[Alu_GK]

Hello -
I started to answer and show how i write the code, and then I Relised that i
called the Requery of Form A on an "on open" event instead of the "on load"
event.
I've changed it, and it worked.
The problem was the requry in the wrong event.
Thanks !