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

Darren DICK darrend at nimble.com.au
Fri Jun 9 08:16:44 CDT 2006


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
 



More information about the AccessD mailing list