>>>>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