Referencing columns in the underlying row

[rootbear]

The answer to my question might be obvious to all but me but here goes....

I'm writing an Event Procedure. I know how to reference fields on the Form but, for the life of me, how do you reference a column in the underlying record (i.e current row of the recordset)? In other words, the field/column is NOT displayed on the form.

Help much appreciated...

 

[neileg]

Why not put it on the form? If you don't want the user to see it, make it invisible. You can reference invisible controls just the same as visible ones.

 

[rootbear]

Thanks for the reply, Neil, but what you're suggesting is impractical in this case. The calculations and processing to be done require a large number of columns/fields from the underlying row and the form isn't large enough to contain them all... even if I resize them to be tiny! I really, really, really need to be able to reference those columns! Surely this is possible, no?

 

[JP-C]

If the field you want to address is included in the query you've based your form on then you should be able to reference it if you know it's name even if it's not >on< the form. You won't be able to access any other properties other than .value though.

Try typing the first few letters of the field and pressing ctrl+Enter and see if it autocompletes or if it's in the list when the code completion kicks in.

I know this worked for me on a query based form but i think it should work the same if you based your form directly off the table.

Hope this helps

 

[neileg]

I'm struggling to understand how much processing you might need. If it's really that extensive, why don't you do it in the underlying query, rather than on the form.