[AccessD] Record Count Problem

If rs.BOF = True And rs.EOF = True and rs.recordcount = 0 Then 
	GoTo GoodBye
Else
	Goto WaveHelloToRocky
End if


Or save the PK, then requery, then find saved PK and position on it.


Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: 16 February 2009 19:09
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Record Count Problem

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