Is the following code snippet alright?
It's the seek usage i've never used, so i'm a little unsure about it.
Code:
'add up int terms
iTerms = 0
RateRS.Seek "=", AccsRS!ACCOUNT_NO, AccsRS!SUBACC_NO
Do Until RateRS.NoMatch
iTerms = iTerms + RateRS!TERM_BAND_LENGTH
RateRS.Seek ">", AccsRS!ACCOUNT_NO, AccsRS!SUBACC_NO
Loop