Hello all,

I have a simple form with a button and text field.

All I want to do is press button and the text field value is inserted into
the variable. I have done the following:-

Dim Subfolder As String
Subfolder = Me![Text1]

but it returns an error message of 'Object doesn't support this property or
method'.

Please could someone point me in the right direction.

Thank you

Graham

Subfolder might be a reserved word, try using another variable name. Also you
only need [ ] around a name if it has embedded spaces or special characters.
Are you sure there is a control called Text1, use the intellisense to make
sure, type Me. and then you will get a list.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"geeves1293" wrote:

> Hello all,
>
> I have a simple form with a button and text field.
>
> All I want to do is press button and the text field value is inserted into
> the variable. I have done the following:-
>
> Dim Subfolder As String
> Subfolder = Me![Text1]
>
> but it returns an error message of 'Object doesn't support this property or
> method'.
>
> Please could someone point me in the right direction.
>
> Thank you
>
> Graham
>