[AccessD] A2000: Move to next record - Not Bound

DWUTKA at marlow.com DWUTKA at marlow.com
Fri Jun 9 10:03:39 CDT 2006


First of all, congratulations! ;)

Second, unless I am dealing with a huge recordset, I prefer to create a
record 'class', one with a property for each field.  I then load the
recordset (when the form loads), and set a collection behind the form,
containing all of the records.  Then you can add 'navigation' buttons which
simply load the next or previous record.

Drew

-----Original Message-----
From: Darren DICK [mailto:darrend at nimble.com.au]
Sent: Friday, June 09, 2006 8:17 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A2000: Move to next record - Not Bound


Hi all
I am going to try an unbound experiment (I know I know) - all the Unbounders
-
back in yer seats
 
So...What's the syntax for not binding a form to a table or query
 
I assume you find the first record in the table you want to display and bind
the
form to one record at a time?
(So it's not true unbound - I agree but...)
 
How do you move to the next or previous records?
Using something like... 
select * from Accounts where AccountID = me.txtAccountID + 1 
won't successfully navigate me forward or back - I need to 'ignore' deleted
records etc
 
So what's the general consensus for navigating forward and back through
single
records at a time?
 
many thanks in advance
 
Darren
 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list