[AccessD] Keeping place after requerying

Selina:

When I need to do this I save a value or combination of values that makes
the record unique.  Then after the Requery I use RecordsetClone and Bookmark
to move back to the desired record. If I delete a record, I save the fields
of the previous or following record.

HTH

Rocky

----- Original Message ----- 
From: "Selina Iddon" <selina at easydatabases.com.au>
To: <accessd at databaseadvisors.com>
Sent: Thursday, June 19, 2003 6:47 AM
Subject: Re: [AccessD] Keeping place after requerying


> Hi Gustav
> When I delete a record it puts #DELETED# across all the fields.  I requery
> it so that they don't see this.
> Thanks
> Selina
>
> --------------------------------------------------------------------------
--
> ---- Selina Iddon selina at easydatabases.com.au Ph: 0414 225 265 Easy Access
> Databases
> ----- Original Message ----- 
> From: "Gustav Brock" <gustav at cactus.dk>
> To: <accessd at databaseadvisors.com>
> Sent: Thursday, June 19, 2003 5:26 PM
> Subject: Re: [AccessD] Keeping place after requerying
>
>
> > Hi Selina
> >
> > > I understandably annoyed customer because everytime they delete
> something
> > > from their very long list and the data is requeried (via code), they
end
> up
> > > at the top of their list again and have to scroll down.
> > > Can anyone please help in how I keep the focus on the next record to
the
> one
> > > they have just deleted?
> >
> > Why do you requery the form? That shouldn't be necessary - except for
> > an unbound form ...
> >
> > /gustav
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>