Try Evaluate(THISFORM.File1+".MyField").
>Hi.
>I have Form Properties declared , at the form level, which hold the name of any temporary Files,Cussors I use during the form.
>e.g. ThisForm.File1 ThisForm.File3 etc
>
>When I want to access fields on these forms, I am having difficulty:
>
>I want to say something like:
>
>ThisForm.File1.Myfield (Myfield is a field on the file)
>
>I have tried various things like:
>&ThisForm.File1 .Myfield
>(ThisForm.File1).Myfield
>(ThisForm.File1) .Myfield but none seem to work
>
>
>I have resorted to following (Which does work)
>lcFile1=ThisForm.File1
>&lcFile1 .Field1 (Space before the dot)
>
>But by doing this, I need to set up an additional variable each time
>Is there any way round this.
>
>regards,
>
>Gerard
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao