Recordset and Field Referencing Questions

[kermit5]

I have some basic questions about how I reference different parts of a recordset. Lets say that in my query, qryRecordSource, I have records 1,2,3 and 4 which each contain vaules for fields A,B,C,D. Graphically, it looks like this:


Record..... A.............B.............C.............D
1.......<valueA1>..<valueB1>..<valueC1>..<valueD1>
2.......<valueA2>..<valueB2>..<valueC2>..<valueD2>
3.......<valueA3>..<valueB3>..<valueC3>..<valueD3>
4.......<valueA4>..<valueB4>..<valueC4>..<valueD4>

I would then use the code:

Dim rst as DAO.Recordset
Dim dbs as DAO.Database
Dim qd as DAO.QueryDef
Dim fld as Field
Dim frm as Form
Dim ctl as Control

Set dbs = CurrentDb
Set qd = dbs.QueryDefs!qryRecordSource
qd.Parameters![MyParam]= "MyValue"
Set rst = qd.OpenRecordset


This much I think I understand. What is the syntax that I need to use to reference the following items:

• the name of field C?
• the 2nd record?
• the value contained in field B of record 4?

Additionally,

• what does frm.Name reference?
• what does fld.Name reference?
• what does ctl.Name reference?

Any help understanding this would be greatly appreciated.

Scott

 

[afloyd]

This looks like your working with a two-dimensional array. You might want to put you recordset into an array and then you will have an easier time referencing specific row,col values.

for example

array(1,2) would be 2nd row, 3rd value. Arrays are zero based when referencing rows and columns.

you will have to do a loop to fill the array, but then life should be much easier if you have to pick a value from in the middle of grid.

HTH

-Al