syntax for field variable

[John]

Can someone please point me in the right direction? I need to substitute a
variable into the following expression.

If IsNull(Forms![Hire Input]![**field name as variable here***].Value)
Then Me!ActiveXCtl1.Value = Date

I could do it through string concatenation

If IsNull(strConcatenated) etc.

but I'm sure there's an easy way and looking this up seemed to draw a blank.
(should I be using the object structure instead? The form containing this
refers to another hidden form.)

Thanks

 

[Allen Browne]

Assuming the field/control name is in a string variable named strField:
Forms

 

[John]

Many thanks Allen...just the job!

Assuming the field/control name is in a string variable named strField:
Forms

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Can someone please point me in the right direction? I need to substitute a
variable into the following expression.

If IsNull(Forms![Hire Input]![**field name as variable here***].Value)
Then Me!ActiveXCtl1.Value = Date

I could do it through string concatenation

If IsNull(strConcatenated) etc.

but I'm sure there's an easy way and looking this up seemed to draw a blank.
(should I be using the object structure instead? The form containing this
refers to another hidden form.)

Thanks