changing vairable according to combobox listinde

[JamesPLile]

i have a function that counts all rows that something in it...
variable = recordNumbers - note its plurale

I have a function that counts up or down the records based on the recordNumber

I'm trying to write a function that will limit the up and down based on the number of rows that fit a certain cell value - in this case state...

using a do untill loop works well the first time I count up or down, after that, if the state stayes the same then the first record is skipped... any suggestions?

[pike]

Hi JamesPLile,
what is the code?