[AccessD] Record Count Problem

I think you need to go to the last record in the rs and then return to your
bookmark before doing anything else. As soon as you open the rs, Access has
no idea of the count.

hth,
Arthur

On Mon, Feb 16, 2009 at 2:09 PM, Rocky Smolin at Beach Access Software <
rockysmolin at bchacc.com> wrote:

> Dear List:
>
> In the following:
>
> Set rs = Me.RecordsetClone
> ' If no records then goodbye:
> MsgBox rs.RecordCount
> If rs.BOF = True And rs.EOF = True Then GoTo GoodBye:
>
> the record count shows as 1 but BOF and EOF are both true.
>
> The record was just added.  So the routine exits instead of doing what it's
> supposed to do.
>
> A Me.Requery solves the problem, but leaves the pointer at the start of the
> the recordset instead of the record the user was working on.
>
> I can's save a bookmark because the Requery triggers the activate event
> which calls this routine and destroys the bookmark.
>
> But why would the record count show 1 when the BOf and EOF are set to True?
>
> TIA
>
>
>
>
>
>
> Rocky Smolin
>
> Beach Access Software
>
> 858-259-4334
>
> www.e-z-mrp.com <http://www.e-z-mrp.com/>
>
> www.bchacc.com <http://www.bchacc.com/>
>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>