Can I convert a String or Variant to Field?

[pjustin1]

Hi,

In my form, the user will define the field he want to search for and edit the data..

I guess I need to convert the user-define field into a field type in order edit the data.. so is there any way to do such a conversion?

Thanks
Justin

 

[Travis]

You can use the String (if its a fields name) Like so:

Forms![YourFormName].Controls(TheString)

This method can also work for forms:

Forms(AStringforFormName).Controls(TheString)