RE: FN-FORUM: Access XP Class Modules

date posted 9th March 2006 17:46

Nicholas Smith wrote:
> I'm not using VB.net I'm using Microsoft Access XP using VBA coding.
>
> I know that the property exists but rather than call the property
> direct I'd rather like to call it using a variable (ie have one
> generic function that is called from numerous places and has
> different inputs)

I don't think you can use a variable as a class property, but you could
create a global function called with the property name as a string then use
a select case over the string to get the relevant property.

So you'd use something like getProperty(Obj,str) instead of Obj(str) in your
code sample.

Andy