Ref string as a field

[Leonard]

Hi

I have a DAO public module that I want other parts of the database to have
access to.

However, I need to use a variable to access a field

(ie)

Rather than use ![Actualfieldname] = "PartNumber"

I want to use a variable for the fieldname


(eg)

![("VariableForFieldName")]="PartNumber"

This is because the fieldname will change when called by different subs.

What is the syntax?

Thanks

Leonard

 

[John Nurick]

Hi Leonard,

If the recordset is rstR and the field name is in strFieldName, try

rstR.Fields(strFieldName).Value

Hi

I have a DAO public module that I want other parts of the database to have
access to.

However, I need to use a variable to access a field

(ie)

Rather than use ![Actualfieldname] = "PartNumber"

I want to use a variable for the fieldname


(eg)

![("VariableForFieldName")]="PartNumber"

This is because the fieldname will change when called by different subs.

What is the syntax?

Thanks

Leonard

 

[Leonard]

Thanks John

Much appreciated solution. Have a great 2005.

Leonard

Hi Leonard,

If the recordset is rstR and the field name is in strFieldName, try

rstR.Fields(strFieldName).Value

Hi

I have a DAO public module that I want other parts of the database to have
access to.

However, I need to use a variable to access a field

(ie)

Rather than use ![Actualfieldname] = "PartNumber"

I want to use a variable for the fieldname


(eg)

![("VariableForFieldName")]="PartNumber"

This is because the fieldname will change when called by different subs.

What is the syntax?

Thanks

Leonard