Using a variable for a field name 3

[RikHess]

I'm sorry if this has been covered before but I don't see it in my archive searches.

I want to use a variable that references a field name in Access VBA. For example, instead of ![FieldName] I'd like to reference something like !strVar to reference the field.

Has someone found a way to do this?

TIA!

 

[jebry]

Hi!

Try this:

Dim strVar As String

strVar = "YourFieldName"
Forms!YourForm.Fields(strVar).etc or
Me.Fields(strVar).etc

Of course strVar can be passed to the function as well.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[RikHess]

Thanks. This was just what I needed.

 

[20fva]

Thankyou

Jerby, found your post helpful 4 months later.

Here is a star.

 

[20fva]

Jerby, I spoke too soon. What library I need to use me.fields()

when i type me. Fields is not on the list and when i type fields( no options of function appear.

thanks in advance

 

[jebry]

Hi!

Absolutely correct! Sorry for the inconvenience. You have a couple of choices:

1.) Open a recordset that is a clone of the recordsource of the form and you will be able to use the .Fields.

2.) Make sure each field in the recordsource of the form is attached to a text box or combo box etc, even if the control is invisible. Then you can use Me.Controls(etc)

hth
Jeff Bridgham
bridgham@purdue.edu

 

[JeremyNYC]

me.Controls(strVar) will work on a form.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[20fva]

THANKYOU BOTH!

-------
Claudia