Hello Everyone,



Can anyone help me?



My database consists of town names and street addresses.  I am using the

find method to find a specific town and a street address.  I can return one

street address or several street addresses for any given town.  What I

really want is to find a town and the first street address, then click on a

button that finds the next street address, then click on a button that finds

the one after that and so on until I run out of records.



What is the best way to code this?



Many thanks,



Gordo

> Hello Everyone,

> 

> Can anyone help me?

> 

> My database consists of town names and street addresses.  I am using the

> find method to find a specific town and a street address.  I can return 

one

> street address or several street addresses for any given town.  What I

> really want is to find a town and the first street address, then click 

on a

> button that finds the next street address, then click on a button that 

finds

> the one after that and so on until I run out of records.

> 

> What is the best way to code this?

> 

> Many thanks,

> 

> Gordo





Easy,



Firs search for all your records, open  a recordset and then use recordset 

paging passing the variables to the next page. Recordset paging will check 

if you are at bof or eof.



Cheers



Markus

> 

>