>I have 10 tables with the same structure and don't know which one will be used until the user make some choices. In the control source I have designated the source A.info where A is determined by a couple inputs by the user and info is a field.
>
Out of curiosity, why would you do this? Why not use a single table with an added field to correspond to the 10 different types of 'whatever' that made you use 10 tables in the first place?

>Question: Is there an easy way to not have the fields show up until the user makes a selection as to which record they wish to view??
>
Sure, do late-binding rather that early binding...