Using Visual Basic to indirectly access a database field 2

[SteveCop]

I have a table containing fields Sales1 through Sales12

Using a For-Next loop I want to address the fields sequentially and have established a routine which, on each pass through, sets the contents of a variable at Sales1, Sales2 etc. The variable is called cField

Problem is, how do I address the database field using the contents of cField rather than the literal string cField?

For example, if I use rcdCustomers![cField] the program will look for a field called cField rather than Sales1.

 

[danvlas]

rcdCustomers(cField) will do.

Dan

 

[SteveCop]

Brilliant! How easy was that (and how much time have I wasted this morning before asking!). Many thanks for your help.

 

[danvlas]

Actually, rcdCustomers![cField] is an Access specific notation and is equivalent to the VB notation rcdCustomers("cField&quot.
If you drop the double quotes, you can use string variables to refer to fields, or forms, or whatever. The "Access specific" notation does not support this.
Luckily, you can use either solution, depending on what you want to do. I myself will stick to the VB one as it will always work.

Dan

 

[Maquis]

Have another star, Dan. I've been trying to figure out how to do the same thing myself for a week now.

The answer's so simple once you know the correct syntax. Maq
<insert witty signature here>