[AccessD] Control which record shows at top of subform

There's a difference between being at the top of the list and being "shown"
at the top of the list.

I've set up some continuous forms that upon opening highlight the line that
corresponds to today's date.  It doesn't put that line at the top of the
list, but it does "look" like it's the top of the list.  I do this by
running thru the recordset until I find the record I want and then set the
bookmark to that record and refresh the form.

If you actually want it at the top could you add a field to the table and
use it as a "marker"?  When you find what should be the first record set the
record to 0 and all the other records in this recordset = 1.  Sort ascending
and you now have the appropriate record at the top.  You could do all this
using the recordsetclone.

I have never tried the second option - it's just an idea.

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of JWColby
> Sent: Wednesday, November 15, 2006 10:20 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Control which record shows at top of subform
>
>
> The short answer is not easily.
>
> If somebody here provides a solution I too will be smiling!
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson
> Sent: Wednesday, November 15, 2006 9:09 AM
> To: AccessD solving'
> Subject: [AccessD] Control which record shows at top of subform
>
> I have a subform and have buttons that navigate to certain records.
> Sometimes when the requested record is located it appears in the middle of
> the subform.
>
> I have the subform sized to show a certain amount of records at a time and
> want the "found" record to be at the top of my list.
>
> Is this possible?
>
>
>
>
>
>
>
>
>
> May God bless you beyond your imagination!
> Lonnie Johnson
> ProDev, Professional Development of MS Access Databases Visit me at ==>
> http://www.prodev.us
>
>
>
> __________________________________________________________________
> __________
> ________
> Sponsored Link
>
> Compare mortgage rates for today.
> Get up to 5 free quotes.
> Www2.nextag.com
> --
> 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
>