How do you reference the field on the form using variable?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barmaley - 03 May 2005 22:10 GMT

I've been using form reference "Forms!Form_Name!Field_Name"

I need to replace Field_Name with variable containing filed name.
Is it possible

AvP

Reply to this Message

Allen Browne - 03 May 2005 22:24 GMT

Try:
strField = "Field1"
Forms!FormName(strField)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I've been using form reference "Forms!Form_Name!Field_Name"
>
> I need to replace Field_Name with variable containing filed name.
> Is it possible

Reply to this Message

Barmaley - 03 May 2005 22:36 GMT

I knew that it gotta be simple

Thank you very much it worked

AvP

> Try:
> strField = "Field1"
[quoted text clipped - 4 lines]
> > I need to replace Field_Name with variable containing filed name.
> > Is it possible

Reply to this Message