>I wanted to remove the alias so the form would work with multiple tables. Thanks for the reply.
>
>Daryl
Daryl,
You have two choices as I can see. (1) open all the tabels with the same alias name so the controls don't know which table it is;
One time
USE Cust1 ALIAS Customer
Next time
USE Cust2 ALIAS Customer
That way the controls are bound to Customer.
. You can sue draga nd drop by placiong any one of the files in the DE for the fomr and setting is the alias property to Customer.
(2) In the form's Load open the atbel with the alias name that the cntrols have to prevent load time errors. Then in the Init close that atble and open the one you want, then iterate through the controls and change the controlsource to remove the alias.