the row i need

'Grade is initalized
Grade = .txtGrade.Text

'step is initalized from RSGrad table
'as the first value in field grstNumber
step = RSGrad!grstNumber

'when the row is the initalized Grade row, get the other
'fields values which are grstStart and grstIncrease
Do Until step = Grade
   step = step +1
   StartAmount = RSGrad!grstStart
   StepInc = RSGrad!grstIncrease

OK i know my loop is ilogical but i don't know how to use the step as an index or something so i can get the values of the other fields.

Who is Participating?
It looks like you're using a Recordset (RSGrad) so why can't you find the record you want by using a SELECT statement?

eg using ADO: SQL = "SELECT fields FROM table WHERE grstNumber = " & Val(txtGrade.Text)
Set RSGrad = New ADODB.RecordSet
RSGrad.Open SQL, connection, adForwardOnly

and then

StartAmount = RSGrad!grstStart
StepInc = RSGrad!grstIncrease
Anthony PerkinsCommented:
Please maintain your open questions:

more than one plot Date: 05/02/2002 05:03PM PST
GD module Date: 04/21/2002 03:39PM PST
imagecreat Date: 04/20/2002 05:31PM PST
charts! Date: 04/18/2002 06:52PM PST
checkbox Date: 04/15/2002 06:50AM PST
Check Boxes Date: 04/06/2002 08:33AM PST
Open a pop-up window Date: 04/05/2002 06:56AM PST
Underlined link Date: 05/16/2002 08:09AM PST

almahaAuthor Commented:
none of them is solved and none of the comments is an answer! what shall i do.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Anthony PerkinsCommented:
Re-read the EE Guidelines ( and / or post a comment in Community Support.

You can chosse not to finalize your questions, just be aware that experts are less inclined to help in this case.  It is your choice.

almahaAuthor Commented:
OK Done will you please help me on my question?
Mahdi MansourDesign Monitoring & Evaluation ManagerCommented:
i don't think that i understand ur question ,,,,,
u want to get the values of the other fileds from the same row ...???!!!!!!

plz clerify ur question more....

Mahdi MansourDesign Monitoring & Evaluation ManagerCommented:
Ya i agree with PNJ , use a select statment ...
almahaAuthor Commented:
it didn't work :s but at least you gave a solution :) thX
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.