>Hi all,
>My form involves an editbox and 4 textboxes which all control sources to a table. This form is not for appending or editing but only for displaying records. How can I interactively change table from a list so that the control source for the textboxes and the editbox also change according to the item selected in the list (which refers to a table in a dir)?Thank you.
>
>
>Regards
>
>Syah N
Yes, you can.
But you must change the fields also, not only tables (if the tables have different structures of course)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.