>>>>>Jim, This form will be used by several dbfs, all with the same structures.
>>>>
>>>>After you do the d and d remove the alias from the controlsource properties. Then remove the dbf from the de.
>>>
>>>Well that's just it, the D & D x50 is ok, but removing the alias x50 could be quite cumbersome.
>>
>>Timothy,
>>
>>You would only have to do the 50 times one time though. It seems like a lot, but once you're done, you're done. Probably only take about 15 minutes really.
>>
>>Renoir
>
>Hi Renoir :)
>He shouldn't one-by-one IMHO. Select all in DE, drag with right button and select 'Create multiple controls here'.
>
>Then select any one control on form and run :
>
>

aselobj(arrForm,1)
>for each oControl in arrForm[1].Controls
> with oControl
> if upper(.Baseclass)='TEXTBOX' and !empty(.Controlsource)
>   .ControlSource = substr(.Controlsource, at('.',.Controlsource)+1)
> endif
> endwith
>endfor

Cetin

Cetin,

Well, sure! If you want to take the automated approach... :-) That's a good idea. Surprised I haven't come across any downloads that do this. I use the ones that allow changes to properties for multiple objects, but not that only change an alias.

Renoir