Prev: Invalid use of Null ----> Help Please
Next: Change Forecolor based upon if statement
From: Maracay on 17 May 2010 13:28
Hi Guys,

I need to know, if I have a variable call (txtField) cointaining the name
of a field of my form ex. txtField="Day1Week2", I want to move 3 to Day1Week2
textbox on my form using txtField.

Thanks
From: Marshall Barton on 17 May 2010 13:45
Maracay wrote:
>I need to know, if I have a variable call (txtField) cointaining the name
>of a field of my form ex. txtField="Day1Week2", I want to move 3 to Day1Week2
>textbox on my form using txtField.

Since variables are strictly a VBA item, they can only be
used in a VBA procedure. Use this kind of syntax:
Me(txtfield) = 3

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Invalid use of Null ----> Help Please
Next: Change Forecolor based upon if statement