Requery

[Daedalus]

Hi
I have an overview form giving consolidated info about orders. With a
detail-button I can access the undelying orderform, update whatever I want,
and get back to the overview. And that's the problem. The overview does not
update until I execute a requery (done in vba). But at that moment I lose
the current row.
Is there a way to refresh/requery the overview without losing the current
row ?

Tanx already !

D

[Bob Quintal]

"Daedalus" <FD*******@hotmail.com> wrote in
news:%K**********************@phobos.telenet-ops.be:

Hi
I have an overview form giving consolidated info about orders.
With a detail-button I can access the undelying orderform,
update whatever I want, and get back to the overview. And
that's the problem. The overview does not update until I
execute a requery (done in vba). But at that moment I lose the
current row. Is there a way to refresh/requery the overview
without losing the current row ?

Tanx already !

Before the requery store the primary key of the row to a variable,
and after the requery, do a findfirst using the variable.

Instead of the requery, you might use a me.refresh, which usually
updates the data on the form.

--
Bob Quintal

PA is y I've altered my email address.

[Pachydermitis]

Lookup help for the bookmark property of a form. That will give you an
example of exactly what you need.
Pachydermitis