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
Loop

------------------------
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.

Maha
almahaAsked:
Who is Participating?
 
PNJCommented:
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
0
 
Anthony PerkinsCommented:
Please maintain your open questions:

more than one plot Date: 05/02/2002 05:03PM PST
http://www.experts-exchange.com/jsp/qShow.jsp?ta=php&qid=20296520
GD module Date: 04/21/2002 03:39PM PST  
http://www.experts-exchange.com/jsp/qShow.jsp?ta=php&qid=20292025
imagecreat Date: 04/20/2002 05:31PM PST
http://www.experts-exchange.com/jsp/qShow.jsp?ta=php&qid=20291829
charts! Date: 04/18/2002 06:52PM PST  
http://www.experts-exchange.com/jsp/qShow.jsp?ta=php&qid=20291201
checkbox Date: 04/15/2002 06:50AM PST
http://www.experts-exchange.com/jsp/qShow.jsp?ta=php&qid=20289592
Check Boxes Date: 04/06/2002 08:33AM PST
http://www.experts-exchange.com/jsp/qShow.jsp?ta=php&qid=20285610
Open a pop-up window Date: 04/05/2002 06:56AM PST
http://www.experts-exchange.com/jsp/qShow.jsp?ta=php&qid=20285309
Underlined link Date: 05/16/2002 08:09AM PST
http://www.experts-exchange.com/jsp/qShow.jsp?ta=dreamweaver&qid=20301321

Thanks,
Anthony
0
 
almahaAuthor Commented:
none of them is solved and none of the comments is an answer! what shall i do.
0
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 (http://www.experts-exchange.com/jsp/cmtyQuestAnswer.jsp) 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.

Anthony
0
 
almahaAuthor Commented:
OK Done will you please help me on my question?
0
 
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....

Kass
0
 
Mahdi MansourDesign Monitoring & Evaluation ManagerCommented:
Ya i agree with PNJ , use a select statment ...
0
 
almahaAuthor Commented:
it didn't work :s but at least you gave a solution :) thX
0
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.