recordset newbie

[swtrader]

I am doing my first VBA coding in Access. Would appreciate some general guidance on how to go about the following:

Very simply, user enters Annual $ Values into a bound subform (bound to an updateable query). I need to extrapolate monthly values from that data. In order to do the calculations I need to pull each applicable query value into a variable (I think), do the machination, append the table to now include a row for that month...loopdeloop.

The piece I can't seem to get down is how to get the values from either a recordset (based on the query) or (less preferred, I think) pull the values from the form sequentially.

So, the question is: can I use a query as the basis for a recordset? If so, do I use rs.MoveNext and Column references to get the data to the variable?

Is there a better way?

thanks to the pros who help out in this forum!

swtrader

 

[bubba100]

If you know (store) the annual value there is no need to calculate and store the monthly value. You can use a query to calculate the monthly value. Yes, a query can be used as a recordset.