>Try doing this:
>
>
>Select INFOBASE
>? RECNO('INFOBASE')
>Replace DAYS_OP with Thisform.cOpDays IN INFOBASE
>? RECNO('INFOBASE')
>
>
>The IN clause might help...
Aye that might have.
See my reply to Mike. I've sorted this now by not using that index order.
Thanks
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.